jsp和mysql连接

最新推荐文章于 2023-05-08 12:30:33 发布

border1985

最新推荐文章于 2023-05-08 12:30:33 发布

阅读量1.1k

点赞数 1

文章标签： mysql jsp border jdbc string exception

本文链接：https://blog.csdn.net/border1985/article/details/324700

版权

jsp和mysql连接

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

中文问题：

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

<%@ page contentType="text/html;charset=gb2312" %>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

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

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

<% request.setCharacterEncoding("GBK"); %>

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

<%@ page contentType="text/html;charset=gb2312" %>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

<%
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");
%>
<html>
<head>
<title>JSP-JDBC-MYSQL TESTING</title>
</head>
<body>
<table border="1" cellspace ="0" align="center">

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

<%@ page contentType="text/html;charset=gb2312" %>
<%
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","");
%>

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

<%@ page import="java.sql.*" %>
<%
out.println(" Border is me ！");

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

}
catch (Exception E) {
out.println("Unable to load driver.");

}
%>

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

4. 若您觉得满意，想转载或收藏这篇文章，我非常感谢，但请您注明作者 border ( border@hacker.cn )

http://blog.csdn.net/border1985

最后欢迎大家访问 --中国安全信息网-- http://www.hacker.cn/