jsp+mysql数据库操作常用方法实例总结
本文实例讲述了jsp+mysql数据库操作常用方法。分享给大家供大家参考。具体如下：
1. 查看：
<%@ page contentType=\"text/html;charset=GB2312\" %>
<%@ page import=\"java.sql.*\" %>
<HTML><style type=\"text/css\">
<!--
body {
background-color: #99CCFF;
}
-->
</style>
<BODY>
<font color=\"#FFFFFF\">
<center>
<% Connection con;
Class.forName(\"com.mysql.jdbc.Driver\");
con = DriverManager.getConnection(\"jdbc:mysql://localhost:3306/student\",\"root\",\"123456\");
Statement sql;
ResultSet rs;
try
{
sql=con.createStatement();
rs=sql.executeQuery(\"SELECT * FROM student\");
out.print(\"<Table Border style=\'font-size: 10pt\'>\");
out.print(\"<TR><td colspan=5 align=center>考生数据</td></tr>\");
out.print(\"<TR><td colspan=5 align=center><a href=\'add.jsp\' target=\'_self\'>添加考生信息</a></td></tr>\");
out.print(\"<TR>\");
out.print(\"<Td width=50 >\"+\"姓名\");
out.print(\"<Td width=100 >\"+\"年龄\");
out.print(\"<Td width=100>\"+\"出生日期\");
out.print(\"<Td width=100 colspan=2>\"+\"操作\");
out.print(\"</TR>\");
while(rs.next())
{ out.print(\"<TR>\");
out.print(\"<TD >\"+rs.getString(2)+\"</TD>\");
out.print(\"<TD >\"+rs.getString(3)+\"</TD>\");
out.print(\"<TD >\"+rs.getString(4)+\"</TD>\");
String idstr=rs.getString(1);
out.print(\"<TD><a href=\'delete.jsp?id=\"+idstr+\"\'>删除</a></TD>\");
out.print(\"<TD><a href=\'update.jsp?id=\"+idstr+\"\'>修改</a></TD>\");
out.print(\"</TR>\") ;
}
out.print(\"</Table>\");
con.close();
}
catch(SQLException e1)
{
out.print(\"SQL异常！！！！\");
}
%>
</center>
</BODY>
</HTML>
2. add 添加：
<%@ page contentType=\"text/html;charset=gb2312\" %>
<HTML><HEAD>
<style type=\"text/css\">
<!--
body {
background-image: url();
background-color: #CCCCFF;
}
.STYLE5 {font-family: \"Courier New\", Courier, monospace; font-size: 14px; }
.STYLE6 {
font-family: \"Courier New\", Courier, monospace;
font-size: 24px;
}
-->
</style>
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\"></HEAD>
<BODY>
<Font size=2>
<p align=\"center\" class=\"STYLE6\">添加考生信息</p>
<CENTER>
<FORM action=\"insert.jsp\" name=form>
<table>
<tr><td height=\"36\"><span class=\"STYLE5\">姓名:</span></td>
<td><Input name=\"name\" type=text size=\"15\" ></td></tr>
<tr>
<td height=\"36\"><span class=\"STYLE5\">年龄:</span></td>
<td><Input name=\"age\" type=text size=\"15\"></td></tr>
<tr>
<td height=\"36\"><span class=\"STYLE5\">出生年月:</span></td>
<td><Input name=\"birth\" type=text size=\"15\"></td></tr>
</table>
<table width=\"165\">
<tr><td width=\"42\" wnameth=\"42\"><Input type=submit name=\"g\" value=\"添加\"></td>
<td width=\"28\" wnameth=\"50\"> </td>
<td width=\"42\" wnameth=\"50\"><Input type=\"reset\" name=\"h\" value=\"重置\"></td>
<td width=\"33\" wnameth=\"42\"> </td>
</tr>
</table>
</Form></CENTER>
</Body></HTML>
3. delete 删除：
<%@ page contentType=\"text/html;charset=gb2312\" %>
<%@ page import=\"java.sql.*\" %>
<html>
<head>
<title>删除操作</title>
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\"><style type=\"text/css\">
<!--
body {
background-color: #FFCCFF;
}
-->
</style></head>
<body>
<center>
<% Connection con;
Class.forName(\"com.mysql.jdbc.Driver\");
con = DriverManager.getConnection(\"jdbc:mysql://localhost:3306/student\",\"root\",\"123456\");
Statement stmt;
Statement s;
ResultSet rs;
String id=request.getParameter(\"id\");
try
{
stmt=con.createStatement();
String sql=\"delete from student where id=\"+id;
stmt.executeUpdate(sql);
s=con.createStatement();
rs=s.executeQuery(\"SELECT * FROM student\");
out.print(\"<Table Border style=\'font-size: 10pt\'>\");
out.print(\"<TR><td colspan=5 align=center>考生数据</td></tr>\");
out.print(\"<TR><td colspan=5 align=center><a href=\'add.jsp\' target=\'_self\'>添加考生信息</a></td></tr>\");
out.print(\"<TR>\");
out.print(\"<Td width=50 >\"+\"姓名\");
out.print(\"<Td width=100 >\"+\"年龄\");
out.print(\"<Td width=100>\"+\"出生日期\");
out.print(\"<Td width=100 colspan=2>\"+\"操作\");
out.print(\"</TR>\");
while(rs.next())
{ out.print(\"<TR>\");
out.print(\"<TD >\"+rs.getString(2)+\"</TD>\");
out.print(\"<TD >\"+rs.getString(3)+\"</TD>\");
out.print(\"<TD >\"+rs.getString(4)+\"</TD>\");
String idstr=rs.getString(1);
out.print(\"<TD >\"+idstr+\"</TD>\");
out.print(\"<TD><a href=\'delete.jsp?id=\"+idstr+\"\'>删除</a></TD>\");
out.print(\"<TD><a href=\'update.jsp?id=\"+idstr+\"\'>修改</a></TD>\");
out.print(\"</TR>\") ;
}
out.print(\"</Table>\");
con.close();
}
catch(SQLException e1)
{
out.print(\"SQL异常！！！！\");
}
%>
</center>
</body>
</html>
4. update 示例1：
<%@ page contentType=\"text/html; charset=gb2312\" language=\"java\" import=\"java.sql.*\" errorPage=\"\" %>
<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">
<html xmlns=\"http://www.w3.org/1999/xhtml\">
<head>
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\" />
<title>无标题文档</title>
<style type=\"text/css\">
<!--
body {
background-color: #FFCCFF;
}
-->
</style></head>
<body>
<%String id=request.getParameter(\"id\");
Connection con;
String name=null;
String age=null;
String birth=null;
String id1=null;
Class.forName(\"com.mysql.jdbc.Driver\");
con = DriverManager.getConnection(\"jdbc:mysql://localhost:3306/student\",\"root\",\"123456\");
Statement sql;
ResultSet rs;
try
{
sql=con.createStatement();
rs=sql.executeQuery(\"SELECT * FROM student\");
while(rs.next())
{
name=rs.getString(2);
age=rs.getString(3);
birth=rs.getString(4);
id1=rs.getString(1);
}
con.close();
}
catch(SQLException e1)
{
out.print(\"SQL异常！！！！\");
}
%>
<center>
<form action=\"update2.jsp\">
<center>
<p> </p>
<p>姓名：
<input name=\"name\" type=\"text\" size=\"15\" value=\"<%=name%>\">
</p>
<p>
年龄：
<input name=\"age\" type=\"text\" size=\"15\" value=\"<%=age%>\">
</p>
<p>出生日期：
<input name=\"birth\" type=\"text\" size=\"15\" value=\"<%=birth%>\">
<input name=\"id1\" type=\"hidden\" value=\"<%=id1%>\" />
</p>
<p><input name=\"g\" type=\"submit\" value=\"修改\"> <input name=\"h\" type=\"reset\" value=\"重置\"></p>
</form>
</center>
</body>
</html>
5. update 示例2：
<%@ page contentType=\"text/html;charset=gb2312\" %>
<%@ page import=\"java.sql.*\" %>
<%
String name=request.getParameter(\"name\");
String age=request.getParameter(\"age\");
String birth=request.getParameter(\"birth\");
String id1=request.getParameter(\"id1\");
System.out.println(id1);
Connection con=null;
try
{
Class.forName(\"com.mysql.jdbc.Driver\");
con = DriverManager.getConnection(\"jdbc:mysql://localhost:3306/student\",\"root\",\"123456\");
Statement sql;
sql=con.createStatement();
String sql2=\"update student set name=\'\"+name+\"\',age=\'\"+age+\"\',birth=\'\"+birth+\"\' where id=\"+id1;
System.out.print(sql2);
int s=sql.executeUpdate(sql2);
}
catch(Exception e){
System.out.println(e);
}
%>
恭喜你，修改成功！<br />
<a href=\"chakan.jsp\">查看</a>
6. insert 插入
<%@ page contentType=\"text/html;charset=gb2312\" %>
<%@ page import=\"java.sql.*\" %>
<%
String name=request.getParameter(\"name\");
String age=request.getParameter(\"age\");
String birth=request.getParameter(\"birth\");
Connection con=null;
try
{
Class.forName(\"com.mysql.jdbc.Driver\");
con = DriverManager.getConnection(\"jdbc:mysql://localhost:3306/student\",\"root\",\"123456\");
Statement sql;
sql=con.createStatement();
String sql2=\"insert into student(name,age,birth) values(\'\"+name+\"\',\'\"+age+\"\',\'\"+birth+\"\')\";
System.out.print(sql2);
int s=sql.executeUpdate(sql2);
}
catch(Exception e){
System.out.println(e);
}
%>
恭喜你，添加成功！<br />
<a href=\"chakan.jsp\">查看</a>
7. 创建数据库
/* MySQL Data Transfer Source Host: localhost Source Database: student Target Host: localhost Target Database: student Date: 2009-3-27 13:24:01 */ SET FOREIGN_KEY_CHECKS=0; create database student; use student; -- ---------------------------- -- Table structure for student -- ---------------------------- CREATE TABLE `student` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) default NULL, `age` varchar(255) default NULL, `birth` varchar(255) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gbk;
希望本文所述对大家的JSP程序设计有所帮助。
本文地址：https://www.stayed.cn/item/9963
转载请注明出处。
本站部分内容来源于网络,如侵犯到您的权益,请 联系我
我的博客
人生若只如初见，何事秋风悲画扇。
我的标签
随笔档案
- 2024-02(2)
- 2023-06(1)
- 2023-05(1)
- 2023-04(14)
- 2023-03(3)
- 2023-01(6)
- 2022-12(5)
- 2022-11(5)
- 2022-07(2)
- 2022-06(4)
- 2022-05(3)
- 2022-03(1)
- 2021-12(6)
- 2021-11(1)
- 2021-10(3)
- 2021-09(5)
- 2021-07(5)
- 2021-02(2)
- 2021-01(7)
- 2020-12(18)
- 2020-11(14)
- 2020-10(12)
- 2020-09(10)
- 2020-08(22)
- 2020-07(2)
- 2020-06(1)
- 2020-04(5)
- 2020-03(9)
- 2020-02(7)
- 2020-01(9)
- 2019-12(8)
- 2019-11(10)
- 2019-10(11)
- 2019-09(17)
- 2019-08(16)
- 2019-07(6)
- 2019-06(3)
- 2019-04(1)
- 2019-03(8)
- 2019-02(5)
- 2019-01(1)
- 2018-11(2)
- 2018-10(3)
- 2018-09(1)
- 2018-08(3)
- 2018-07(3)
- 2018-06(7)
- 2018-04(4)
- 2018-03(5)
- 2018-02(4)
- 2018-01(22)
- 2017-12(3)
- 2017-11(5)
- 2017-10(15)
- 2017-09(26)
- 2017-08(1)
- 2017-07(3)