JSP和MYSQL数据库的连接！！！！！！！！谢谢

Question

http://expert.csdn.net/Expert/topic/2427/2427624.xml?temp=2.962893E-02

Answer 1

import java.sql.*;
public class DBconn
{    config config;
    private String DBdriver = org.gjt.mm.mysql.Driver;
    private String DBurl = "jdbc:mysql://localhost:3306/" + 数据库名 + "?user=" + 用户名 + "&password=" + 密码;
    Statement stmt;
    Connection conn;
    ResultSet rs;    public DBconn()
        throws Exception
    {
        config = new config();
        DBdriver = config.DBdriver;
        DBurl = config.DBurl;
        stmt = null;
        conn = null;
        rs = null;
        try
        {
            Class.forName(DBdriver).newInstance();
        }
        catch(ClassNotFoundException classnotfoundexception)
        {
            System.err.println("DBconn (): " + classnotfoundexception.getMessage());
        }
    }    public void CloseConn()
        throws Exception
    {
        if(rs != null)
            rs.close();
        if(stmt != null)
            stmt.close();
        if(conn != null)
            conn.close();
    }    public ResultSet ExeQuery(String s)
    {
        try
        {
            conn = DriverManager.getConnection(DBurl);
            stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
            rs = stmt.executeQuery(s);
            conn.close();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("ExeQuery:" + sqlexception.getMessage());
        }
        return rs;
    }    public void ExeUpdate(String s)
    {
        try
        {
            conn = DriverManager.getConnection(DBurl);
            stmt = conn.createStatement();
            stmt.executeUpdate(s);
            conn.close();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("ExeUpdate:" + sqlexception.getMessage());
        }
    }
}

Answer 2

按说,Mysql 和 jsp还是很好连的呀,
你检查一下你的mysql驱动,jsp的环境等等,看看又没问题?

Answer 3

在CSDN上找找连接池的例子最好用连接池来做