JSP页面中通过JDBC连接数据库

在做JSP项目中，以前学的都是在需要数据库操作的页面中，加上java代码，数据库操作语句，然后进行数据库的操作。但是现在，随着项目的越来越大，发现这些就是渣渣啊。太弱智了。然后我就用了jdbc连接。然后写一个公共类。通过这个来进行操作。

代码如下：

package db;

import java.sql.*;

public class db {

                privateString dbDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";

                 private String sConnStr ="jdbc:microsoft:sqlserver://localhost:1433;databasename=数据库名";

                  public Connection connect = null;

                  public ResultSet rs=null;

                  public db() {

                    try {

                      Class.forName(dbDriver).newInstance();

                      connect =DriverManager.getConnection(sConnStr,"sa","123456");

                     //用户名sa，密码123456

                    }

                    catch (Exception ex) {

                      System.out.println("12121");

                    }

                  }

                  public ResultSet executeQuery(String sql) {

                                                try{

                                                                connect=DriverManager.getConnection(sConnStr,"sa","123456");

                                                                Statementstmt=connect.createStatement();

                                                                rs=stmt.executeQuery(sql);

                                                }catch(SQLExceptionex){

                                                                System.err.println(ex.getMessage());

                                                }

                                                returnrs;

                                }

                  public void executeUpdate(String sql)

                    {

                                Statementstmt=null;

                                rs=null;

                                try

                                {  connect=DriverManager.getConnection(sConnStr,"sa","123456");

                                                stmt=connect.createStatement();

                                                stmt.executeUpdate(sql);

                                                stmt.close();

                                                connect.close();

                                }

                                catch(SQLException ex)

                                {

                                                System.err.println(ex.getMessage());                   

                                }

                    }

}

然后在需要数据库操作的页面中添加一个行代码

<jsp:useBean id="connDbBean"scope="page" class="db.db"/>

这样就ok了。