importjava.sql.DriverManager;importjava.sql.Connection;importjava.sql.Statement;importjava.sql.ResultSet;importjava.sql.SQLException;public classJDBC_Mysql
{public static voidmain(String []args){//假设sal是从界面上获得的数据
double sal = 1500;
Connection conn= null;
Statement st= null;
ResultSet rs= null;//1:注册驱动
try{/*java.sql.Driver driver = new com.mysql.jdbc.Driver();
DriverManager.deregisterDriver(driver);*/Class.forName("com.mysql.jdbc.Driver");//2:获取连接
String url = "jdbc:mysql://127.0.0.1:3306/test";
String uname= "root";
String pwd= "root";
conn=DriverManager.getConnection(url,uname,pwd);//3:获取数据库操作对象
st =conn.createStatement();//4:执行数据库语句
rs = st.executeQuery("select ename,sal from emp where sal > "+sal);//5:如果是查询就处理结果集
while(rs.next()){/*所有的数据类型都可以使用getString获得值
String name = rs.getString("ename");
String salary = rs.getString("sal");
可读性差,扩展力差。
String name = rs.getString(1);
double salary = rs.getDouble(2);*/String name= rs.getString("ename");double salary = rs.getDouble("sal");
System.out.println("姓名:"+ name +"\t工资:" +salary);
}
}catch(Exception e){
e.printStackTrace();
}finally{//6:释放资源 ,从小到大依次关闭
if(rs != null){try{
rs.close();
}catch(SQLException sqle){
sqle.printStackTrace();
}
}if(st != null){try{
st.close();
}catch(SQLException sqle){
sqle.printStackTrace();
}
}if(conn != null){try{
conn.close();
}catch(SQLException sqle){
sqle.printStackTrace();
}
}
}
}
}