📄 如何使用jsp访问mysql数据库.htm
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- saved from url=(0057)http://eps.www85.cn4e.com/java/article/devshow.asp?id=120 -->
<HTML><HEAD><title>csdn_如何使用JSP访问MySQL数据库</TITLE>
<META content="text/html; charset=gb2312" http-equiv=Content-Type>
<STYLE type=text/css>TD {
FONT-FAMILY: "Verdana", "Arial", "宋体"; FONT-SIZE: 9pt
}
A {
COLOR: #660000; TEXT-DECORATION: underline
}
A:hover {
COLOR: #660000; TEXT-DECORATION: none
}
.line {
LINE-HEIGHT: 14pt
}
</STYLE>
<META content="MSHTML 5.00.2920.0" name=GENERATOR></HEAD>
<BODY bgColor=#ffffff text=#000000>
<table><tbody>
<TR>
<TD height=21>
<DIV align=center><B><FONT size=3>如何使用JSP访问MySQL数据库
<BR><FONT size=2> </FONT></FONT></FONT>
<HR align=center color=#cccccc noShade SIZE=1>
</DIV></TD></TR>
<TR>
<TD class=line><FONT
color=#333300><%@page import="java.sql.*" <BR>import ="java.util.*" <BR>import ="java.io.*" <BR>contentType="text/html; charset=gb2312" <BR>%> <BR><html> <BR><head> <BR><title>使用MYsql数据库</title> <BR><meta name="GENERATOR" content="Microsoft FrontPage 4.0"> <BR><meta name="ProgId" content="FrontPage.Editor.Document"> <BR></head> <BR><body> <BR><p align="center"><u><font size="5" face="华文新魏">使用JSP读取Mysql数据库</font></u></p> <BR><%! <BR>String host="localhost"; //数据库主机 <BR>String database="pinghui"; //数据库名 <BR>String user="test"; //用户名 <BR>String pass=""; //口令 <BR>%><% java.sql.Connection sqlConn; //数据库连接对象 <BR>java.sql.Statement sqlStmt; //语句对象 <BR>java.sql.ResultSet sqlRst; //结果集对象 <BR>//登记JDBC驱动对象 <BR>Class.forName ("org.gjt.mm.mysql.Driver").newInstance (); <BR>//连接数据库 <BR>sqlConn= java.sql.DriverManager.getConnection ("jdbc:mysql://"+host+"/"+database,user,pass); <BR>//创建语句对象 <BR>sqlStmt=sqlConn.createStatement (java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY); <BR>//执行Sql语句 <BR>String sqlQuery="select count(*) from comment"; <BR>sqlRst=sqlStmt.executeQuery (sqlQuery); <BR>sqlRst.next(); <BR>int count=sqlRst.getInt(1); //取得总的留言记录数 <BR>sqlQuery="select * from comment order by userid desc;"; <BR>sqlRst=sqlStmt.executeQuery (sqlQuery); //执行SQL语句 <BR>%> <BR>总共有<%=count%>条留言 <BR><table border="1" width="100%" bordercolorlight="#CC99FF" cellpadding="2" bordercolordark="#FFFFFF" cellspacing="0"> <BR><tr> <BR> <td align="center"> ID</td> <BR> <td align="center">昵称</td> <BR> <td align="center">性别</td> <BR> <td align="center">地址</td> <BR> <td align="center">IP地址</td> <BR> <td align="center">邮编</td> <BR> <td align="center">Oicq</td> <BR> <td align="center">ICQ</td> <BR> <td align="center">电话</td> <BR> <td align="center">留言</td> <BR> <td align="center">时间</td> <BR></tr> <BR><% while (sqlRst.next()) { //取得下一条记录 %> <BR><tr><!--显示记录--> <BR> <td><%=sqlRst.getString("userid")%></td> <BR> <td><%=sqlRst.getString("username")%></td> <BR> <td><%=sqlRst.getString("sex")%></td> <BR> <td><%=sqlRst.getString("address") %></td> <BR> <td><%=sqlRst.getString("ip") %></td> <BR> <td><%=sqlRst.getString("post")%></td> <BR> <td><%=sqlRst.getString("oicq")%></td> <BR> <td><%=sqlRst.getString("icq")%></td> <BR> <td><%=sqlRst.getString("telnumber")%></td> <BR> <td><%=sqlRst.getString("comment")%></td> <BR> <td><%=sqlRst.getString("time") %></td> <BR></tr> <BR><% } %> <BR></table> <BR></body> <BR><% <BR>//关闭结果集对象 <BR> sqlRst.close(); <BR> //关闭语句对象 <BR>sqlStmt.close (); <BR>//关闭数据库连接 <BR>sqlConn.close(); <BR>%> <BR></FONT></TD></TR>
<TR>
<TD height=5>
<HR align=center color=#cccccc noShade SIZE=1>
</TD></TR></TBODY></BODY></HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -