jsp连接MYSQL的问题

Question

我想用JDBC连接MYSQL数据库,代码如下"jdbc:mysql://localhost/BookStore?user=root&useUnicode=true&characterEncoding=8859_1"我的用户名想用默认的root密码用19850209该怎么改代码才能实现呀

Answer 1

端口没给吧
mysql默认使用3306
jdbc:mysql://localhost:3306/BookStore?user=root&useUnicode=true&characterEncoding=8859_1

Answer 2

import java.util.HashMap;public class Conn2Mysql {
public static void main(String[] args) throws Exception {
java.sql.Connection sqlConn;
java.sql.Statement sqlStmt;
java.sql.ResultSet sqlRst;
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
sqlConn = java.sql.DriverManager.getConnection(
"jdbc:mysql://localhost:3306/db1?characterEncoding=gb2312",
"username", "password");
sqlStmt = sqlConn.createStatement(
java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,
java.sql.ResultSet.CONCUR_READ_ONLY);
sqlRst = sqlStmt.executeQuery("select a,b from tbl_test order by b");
HashMap map = new HashMap();
while (sqlRst.next()) {
String a=sqlRst.getString(1);
String b=sqlRst.getString(2);
Integer I = new Integer(b);
if(map.get(I)==null){
       map.put(I,a);
       System.out.println();
       System.out.println("组号"+b);
       System.out.println();
}
System.out.println(a);
}
sqlRst.close();
sqlStmt.close();
sqlConn.close();
}
}

Answer 3

Class.forName("org.gjt.mm.mysql.Driver").newInstance();   String url ="jdbc:mysql://localhost/BookStore?
  user=root & password=19850209 & useUnicode=true&characterEncoding=8859_1" Connection conn= DriverManager.getConnection(url);   
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);