证券信用风险分析报告:JAVA 如何连接数据库和 对记录集的访问

比如连接最常用的sql server
需要下载jdbc驱动.下载jdbc驱动包,安装之后,打开那个文件夹,你会看到三个jar包,只要把这三个jar包设置到环境变量(classpath)里就可以了,象这样
假设你安在d盘的tomcat\lib目录下,那么就是

安装之后,打开那个文件夹,你会看到三个jar包,只要把这三个jar包设置到环境变量(classpath)里就可以了,象这样
假设你安在d盘的sqldriver目录下,那么就是

d:\sqldriver\msbase.jar;d:\sqldriver\mssqlserver.jar;d:\sqldriver\msutil.jar;
====================================================================
import java.sql.*;
public class SqlTesting {
public static void main(String args[]) {
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Northwind";
String user ="sa";
String password = "sa";
String sqlStr = "select CustomerID, CompanyName, ContactName from Customers";

try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con = DriverManager.getConnection( url, user, password );
Statement st = con.createStatement();

ResultSet rs = st.executeQuery( sqlStr );
System.out.println( "----------------!" );

while(rs.next()) {
System.out.print(rs.getString("CustomerID") + " ");
System.out.print(rs.getString("CompanyName") + " ");
System.out.println(rs.getString("ContactName"));
}
rs.close();
st.close();
con.close();
} catch(Exception err) {
err.printStackTrace(System.out);
}
}
}

昏,又是写在页面的垃圾代码