搜集的资料如下:
public class www {
public static void main(String[]args) throws Exception {
//第一步:加载驱动(驱动jar包必须加入classpath中)
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
//第二步:建立连接(根据实际情况替换数据库的主机地址、端口号、数据库明、登录名、密码)
Connection conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=shijiuban1", "sa", "111111");
System.out.println("当前连接到的数据库="+conn.getCatalog());//查看当前连接到的数据库名
//第三步:创建Statement对象
Statement stmt = conn.createStatement();//只读的结果集
//Statement stmt2 = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);//可更新的结果集
//第四步:执行操作(增删改查)
ResultSet rs = stmt.executeQuery("select * from stt");
//处理结果
while(rs.next()){
System.out.println(rs.getString("1"));
}
//第五步:关闭连接
conn.close();
}
}
我自己的代码:
package DB;
import java.sql.*;
public class TestDB{
//private Connection conn = null;
//private Statement stat = null;
//private ResultSet rst = null;
public static void main(String args[]) throws Exception {
//Class.forName("com.mysql.jdbc.Driver").newInstance();
Class.forName("org.gjt.mm.mysql.Driver").newInstance();//驱动jar包必须加入classpath中
String url = "jdbc:mysql://localhost:3306/mr?user=root&password=&useUnicode=true&characterEncoding=gb2312";
Connection conn = DriverManager.getConnection(url);
Statement stat = conn.createStatement();
String sql = "select * from uchome_member";
ResultSet rs = stat.executeQuery(sql);
while(rs.next()){
System.out.println(rs.getString(2));
}
rs.close();
stat.close();
conn.close();
}
}
测试通过