mysql和jsp连接代码_jsp和mysql连接

中文问题：

jsp和mysql连接的时候，要在每一个jsp文件中加：

http://www.gaodaima.com/42877.htmljsp和mysql连接

如果是表单的提交要加上：

jdbc:mysql://127.0.0.1:3306/publish?useUnicode=true&characterEncoding=GBK" 和

############################################################################

1.

java.sql.Connection sqlConn;

java.sql.Statement sqlStmt;

java.sql.ResultSet sqlRst;

//regiester jdbc driver

String DBUser="root";

String DBPassword="root";

String DBServer="127.0.0.1"; // Can't use localhost , you must use IP or CNAME

String DBNAME="publish"; // change to your db name

Class.forName("org.gjt.mm.mysql.Driver").newInstance();

//connect to the database

sqlConn=java.sql.DriverManager.getConnection

("jdbc:mysql://"+DBServer+":3306/"+DBNAME+"?useUnicode=true&characterEncoding=gb2312",

DBUser,DBPassword);

//create the driver handle

sqlStmt=sqlConn.createStatement

(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);

//excute sql

sqlRst=sqlStmt.executeQuery("select * from book");

%>

JSP-JDBC-MYSQL TESTING

ID	Book name

//sqlRst.close();

sqlStmt.close();

sqlConn.close();

%>

………………………………………………………………………………

2.

java.sql.Connection conn;

java.lang.String strConn;

Class.forName("org.gjt.mm.mysql.Driver").newInstance();

conn= java.sql.DriverManager.getConnection("jdbc:mysql://127.0.0.1/test","root","");

%>

………………………………………………………………………………

3.

out.println(" Border is me ！");

try {

Class.forName("org.gjt.mm.mysql.Driver").newInstance();

}

catch (Exception E) {

out.println("Unable to load driver.");

}

%>

………………………………………………………………………………

欢迎大家阅读《jsp和mysql连接》,跪求各位点评,若觉得好的话请收藏本文，by 搞代码

原创文章，转载请注明： 转载自搞代码

微信 赏一包辣条吧~

支付宝 赏一听可乐吧~