下面我们以连接SQLServer2005为例说一下JDBC连接步骤
1.加载驱动
Class.forName(DRIVER);
2.创建连接
Connection ct=DriverManager.getConnection("jdbc:sqlserver://127.0.0.1;databaseName=test","sa","111111");
3.执行sql语句
PreparedStatement ps=ct.prepareStatement(sql);
4.将数据存入结果集
ResultSet rs=ps.executeQuery();
下面我们看一下完整的代码
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;
public class ConnDB {
private static final String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
private String sql = "select * from users";
public Connection getConn() {
try {
Class.forName(DRIVER);
Connection ct=DriverManager.getConnection("jdbc:sqlserver://127.0.0.1;databaseName=test","sa","111111");
PreparedStatement ps=ct.prepareStatement(sql);
ResultSet rs=ps.executeQuery();
while(rs.next()) {
//rs.getString(1)中的1代表取得sql表中第一列数据
System.out.println(rs.getString(1));
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return ct;
}
public static void main(String[] args) {
ConnDB conndb = new ConnDB();
conndb.getConn();
}
}