package mysql;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
/*
* 使用PreparedStatement接口实现数据表的查询操作
* 查询建议用PreparedStatement具有高效
*/
public class JDBCDEMO5 {
public static void main(String[] args) throws Exception {
// TODO Auto-generated method stub
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection
("jdbc.mysql://localhost:3306/mybase","root","root");
String sql = "SELECT * FROM sort";
PreparedStatement pst = con.prepareStatement(sql);
// 调用pst对象的方法,执行查询语句,Select
ResultSet rs = pst.executeQuery();
while(rs.next()) {
System.out .println(rs.getString("id") + " " + rs.getString("sname")
+ " " + rs.getString("sprice") + " " + rs.getString("sdesc"));
}
rs.close();
pst.close();
con.close();
}
}