java sql代码_有关在java中使用sql代码

String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

String URL = "jdbc:sqlserver://localhost:1433;databaseName=数据库的名字";

String USER ="test";

String PWD = "12345";

Connection con = null;

Statement ps=null;

ResultSet rs=null;

String sql="select * from student";

try {

Class.forName(DRIVER);

con = DriverManager.getConnection(URL, USER,PWD);

ps=con.createStatement();

rs=ps.executeQuery(sql);

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

//其中sql是查询语句，里面放入查询语句，USER是数据库用户名，PWD是密码，rs是结果集，用来接收查询结果

取消

评论