JDBC编程六部曲:
1、注册驱动器
2、获取数据库连接
3、获取连接数据库对象
4、执行sql语句
5、处理查询结果集
6、关闭释放
import java.sql.*;
public class StatementTest
{
public static void main(String[] args) throws Exception{
//1、注册驱动器
/* java.sql.Driver driver = new com.mysql.jdbc.Driver();
java.sql.DriverManager.registerDriver(driver);
因为registerDriver()该方法是静态方法,当类加载至jvm是便执行,所以只需将类Driver加载即可
*/
Class.forName("com.mysql.jdbc.Driver");
//2、获取数据库连接
//URL格式: 协议---IP---Port---DBNAME:其中localhost为本地ip,端口为:3306,数据库名称:bjpowernode,用户名:root 密码:333
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/bjpowernode","root","333");
//3、获取连接数据库对象
Statement stat = conn.createStatement();
//4、执行sql语句
String sql = "select * from emp where ename = 'king'";
//executeQuery(String sql)方法为处理查询语句,更新数据库的语句是executeUpdate(String sql);
//创建一个接收结果集,
ResultSet rs = stat.executeQuery(sql);
//5、处理查询结果集
while(rs.next()){
String ename = rs.getString("ename");
int empno = rs.getInt("empno");
String job = rs.getString("job");
int mgr = rs.getInt("mgr");
Date date = rs.getDate("hiredate");
double sal = rs.getDouble("sal");
double comm = rs.getDouble("comm");
int deptno = rs.getInt("deptno");
System.out.println("ename="+ename+" emptno="+empno+" job="+job+" mgr="+mgr+" date="+date+sal+" comm="+comm+" deptno="+deptno);
}
//6、关闭释放
if(rs!=null){
rs.close();
}
if(stat!=null){
stat.close();
}
if(conn!=null){
conn.close();
}
}
}