java jdbc操作SQLServer数据库
public static void main(String args[]){ System.out.println(321); PreparedStatement ps = null; ResultSet rs = null; Connection ct = null; try{ Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); String url = "jdbc:microsoft:sqlserver://serverxp.com:1433;DatabaseName=project_students"; String user="sa"; String pwd2 = "sa"; ct = DriverManager.getConnection(url, user, pwd2); String sql ="SELECT * FROM stu WHERE 1=? "; ps=ct.prepareStatement(sql); ps.setString(1, "1"); rs=ps.executeQuery(); while(rs.next()){ System.out.println(rs.getString("stuName")); } }catch(Exception ex){ ex.printStackTrace(); }finally{ if(null!=rs){ try { rs.close(); } catch (Exception e) { // TODO: handle exception e.printStackTrace(); } rs=null; } if(null!=ps){ try { ps.close(); } catch (Exception e) { // TODO: handle exception e.printStackTrace(); } ps = null; } if(null!=ct){ try { ct.close(); } catch (Exception e) { // TODO: handle exception e.printStackTrace(); } ct=null; } } }
郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。