Zusammenfassung von Beispielen gängiger Methoden für JSP+MySQL-Datenbankoperationen
- 高洛峰Original
- 2016-12-27 13:41:362058Durchsuche
Die Beispiele in diesem Artikel beschreiben gängige Methoden für JSP+MySQL-Datenbankoperationen. Teilen Sie es als Referenz mit allen. Die Details lauten wie folgt:
1. Anzeigen:
<%@ 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. Hinzufügen:
<%@ 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 🎜> 4. Update-Beispiel 1:
<%@ 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>5. Update-Beispiel 2:
<%@ 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>6. Datenbank erstellen
<%@ 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>Ich hoffe, dass dieser Artikel für das JSP-Programmierdesign aller hilfreich sein wird.
<%@ 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>Weitere Beispiele und Zusammenfassungen gängiger Methoden für JSP+MySQL-Datenbankoperationen finden Sie auf der chinesischen PHP-Website! Stellungnahme：
Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn
Vorheriger Artikel：Beispielcode für den Joomla-DatenbankbetriebNächster Artikel：Beispielcode für den Joomla-Datenbankbetrieb