语法
public static void main(String[] args) throws Exception{
//注册驱动
Class.forName("com.mysql.cj.jdbc.Driver")
Connection conn=DriverMananger.getConnection(url,user,pwd)
//Statement st =conn.createStatement();不安全
String sql ="select * from user where name=?"
PrepareStatement ps=conn.prepareStatement(sql) //安全
ps.setString(1,设置值) 设置第一个?的值
//可以有多个,根据具体的sql语句而定
ResultSet rs = ps.executeQuery();
while( rs.next() ){
//具体业务操作
}
rs.close();
ps.close();
conn.close();
}