java sql

关于Java中的sql编写  

首先导入 import java.sql.*;

Connection cn = null;

PrepareStatement =null;

ResultSet rs = null;      //查询

try{

             Class.forName("org.gjt.mm.mysql,Driver");   // 加载驱动

             cn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/qq","root","1234");

             ps = cn.prepareStatement("select * from user where username =  ? and password = ?" );

             ps.setString(1,..);

             ps.setString(2,....);

             rs = ps.executeQuery();

}

catch(Exception e ){

 

}

finally{

           cn.close();

           ps.close();

           rs.close();

 

 

}