 当前位置：首页 > 帮助中心 >如何用JSP连接MYSQL数据库?
|
|
JSP连接MYSQL的例子:
<%@page contentType="text/html;charset=gb2312"%>
<%
//声名
java.sql.Connection sqlConn;
java.sql.Statement sqlStmt;
java.sql.ResultSet sqlRst;
String DBUser="";//MYSQL数据库用户名
String DBPassword="";//MYSQL密码
String DBServer="localhost"; //MYSQL服务器，默认的就可以
String DBNAME="mytable"; //MYSQL数据库名称
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
sqlConn=java.sql.DriverManager.getConnection
("jdbc:mysql://"+DBServer+":3306/"+DBNAME+"?useUnicode=true&characterEncoding=gb2312", DBUser,DBPassword);
sqlStmt=sqlConn.createStatement();
sqlStmt=sqlConn.createStatement();
sqlRst=sqlStmt.executeQuery("select * from mytable"); //注意表名称
%>
<html>
<head>
<title>Linux-JSP-JDBC-MYSQL TESTING -SELETCT</title>
</head>
<body>
<table border="1" cellspace ="0" align="center">
<tr><td>DB CONNECT OK , </td></tr>
<tr>
<th>title </th>
<th>type </th>
</tr>
<% while(sqlRst.next()) {%>
<tr>
<td> <%=sqlRst.getString(name)%></td> //注意表字段
<td><%=sqlRst.getString(password)%></td> //注意表字段
</tr>
<%}%>
</table>
</body>
</html>
<%
sqlRst.close();
sqlStmt.close();
sqlConn.close();
%>
|
QQ:
：zcdnsz#126.com