添加数据库驱动(.jar)也就是jar包(
mysql-connector-java-5.1.7-bin.jar)
实现JDBC操作:
1)注册驱动:
方法一:DriverManager.registerDriver(new com.mysql.jdbc.Driver());(抛出异常)(不推荐使用)
方法二:
Class.forName("com.mysql.jdbc.Driver");(推荐使用)
2)获取连接:
方法一:
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/数据库名","数据库用户名","密码");;
方法二:
String url = "jdbc:mysql://localhost:3306/数据库名";
Properties info = new Properties();
info.setProperty("user","root");
info.setProperty("password","abc");
Connection conn = DriverManager.getConnection(url,info);
方法三:
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/数据库名?user = 数据库用户名&password = 密码");
3)得到执行sql语句的对象Stament:
Statement stmt = conn.createStatement();
例:
Connection conn = null;
PreparedStatement stmt = null;
try{
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://127.0.0.1:3360/student";
String user = "root";
String password = "123456";
conn = DriverManager.getConnection(url,user,password);
String sql = "INSERT INTO course vALUES(?,?,?)";
stmt = conn.prepareStatement(sql);
stmt.setString(1,cno);
stmt.setString(2,cname);
stmt.setString(3,tno);
int res = stmt.executeUpdate();
}catch(Exeception e){
System.out.println("发生异常");
}finally{
rs.close();
stmt.close();
conn.close();
}
4)执行sql语句,并返回结果:
ResultSet rs = stmt.executeQuery("sql语句");根据查询语句返回结果集,只能执行select语句
int executeUpdate(String sql)根据执行的DML语句,返回受影响的行数
5)处理结果集:
while(rs.next()){
System.out.println(rs.getObject(1(代表第一列)));
System.out.println(rs.getObject(2(代表第二列)));
......
System.out.println(rs.getObject(n(代表第N列)));
(或者向里面传入列的名字,以字符串的形式传入)
}
6)关闭资源:
rs.close();
stmt.close();
conn.close();