Question

Eclipse用JDBC-ODBC桥连接的方式连接SQLServer2005数据库的问题

Answer 1

packagecom.Dao;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjavax.servlet.jsp.jstl.sql.Result;importjavax.servlet.jsp.jstl.sql.ResultSupport;publicclassDbHelper{privatestaticfinalStringDRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";privatestaticfinalStringURL="jdbc:sqlserver://localhost;databasename=db_Blog";privatestaticfinalStringUID="sa";privatestaticfinalStringPWD="sasa";publicstaticConnectiongetConnection(){Connectioncon=null;try{Class.forName(DRIVER);con=DriverManager.getConnection(URL,UID,PWD);System.out.println("连接数据库成功");}catch(Exceptione){e.printStackTrace();System.out.println("sb");}returncon;}publicstaticvoidmain(String[]p){getConnection();}publicstaticResultrunSelectSql(Stringsql){Connectioncon=null;PreparedStatementpst=null;ResultSetres=null;Resultresult=null;try{con=getConnection();pst=con.prepareStatement(sql);res=pst.executeQuery();result=ResultSupport.toResult(res);}catch(Exceptione){e.printStackTrace();//TODO:handleexception}finally{try{}catch(Exceptione2){e2.printStackTrace();//TODO:handleexception}}returnresult;}publicstaticResultrunSelectSql(Stringsql,Object[]params){Connectioncon=null;PreparedStatementpst=null;ResultSetres=null;Resultresult=null;try{con=getConnection();pst=con.prepareStatement(sql);for(inti=0;i0){flag=true;}else{flag=false;}}catch(Exceptione){e.printStackTrace();//TODO:handleexception}finally{try{}catch(Exceptione2){e2.printStackTrace();//TODO:handleexception}}returnflag;}}这是以前我们课上写的你看看