jsp连接MySQL数据库代码

jsp连接MySQL数据库的代码是什么？极悦小编来告诉大家。

1.下载驱动mysql-connector-java-*.*.*-bin.jar 放到WEB-INF/lib/下，记得重启tomcat。

2.示例代码如下。

    String driverName="com.mysql.jdbc.Driver";
    String userName="username";
    String userPasswd="password";
    String dbName="dbname";
    String tableName="tablename";
    String url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPasswd;
    Class.forName("com.mysql.jdbc.Driver").newInstance();
    Connection conn=DriverManager.getConnection(url);
    Statement statement = conn.createStatement();
    String sql="SELECT * FROM "+tableName;
    ResultSet rs = statement.executeQuery(sql);
    // get the result
    ResultSetMetaData rmeta = rs.getMetaData();
    // the the number of columns
    int numColumns=rmeta.getColumnCount();
    // out each field
    while(rs.next()) {
        out.print(rs.getString(1)+" ");
        out.print("|");
        out.print(rs.getString(2));
        out.print("
    ");
    }
    out.print("
    ");
    out.print("Operations on the DB is done.");
    rs.close();
    statement.close();
    conn.close();