JDBC连接SQLserver2012

只需要直接创建工程后修改密码和语句就可以直接运行了importjava.sql.*;publicclassconnect{publicstaticvoidmain(String[]args){Stringsno=null;Stringsname=null;Stringssex=null;Stringsdept=null;intsage=0;//Stringquery2=INSERTINTOS(Sno,Sname,Sdept,Ssex,Sage)VALUES(,'',,'',);Stringquery=SELECTSno,Sname,Sdept,Ssex,SageFROMS;StringdriverName=com.microsoft.sqlserver.jdbc.SQLServerDriver;StringdbURL=jdbc:sqlserver://localhost:1433;DatabaseName=student;StringuserName=sa;//用户名StringuserPwd=;//密码System.out.println(正在建立连接。。。);try{//加载驱动程序Class.forName(driverName);//建立连接ConnectiondbConn=DriverManager.getConnection(dbURL,userName,userPwd);//创建一个数据库对象Statementstmt=dbConn.createStatement();//stmt.addBatch(query2);//执行插入语句//执行查询语句ResultSetrs=stmt.executeQuery(query);System.out.println(连接成功);//执行之后获得数据库的数据while(rs.next()){sno=rs.getString(Sno);sname=rs.getString(Sname);ssex=rs.getString(Ssex);sdept=rs.getString(Sdept);sage=rs.getInt(Sage);System.out.println(Sno:+sno+,+Sname:+sname+,+Ssex:+ssex+,+Sage:+sage+,+Sdept:+sdept);}}catch(Exceptione){e.printStackTrace();System.out.print(连接失败);}}}