Résumé des méthodes courantes pour les opérations de base de données jsp mysql
- 高洛峰original
- 2016-12-27 13:41:362011parcourir
Les exemples de cet article décrivent les méthodes courantes d'opérations de base de données jsp mysql. Partagez-le avec tout le monde pour votre référence. Les détails sont les suivants :
1. Vue :
<%@ 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 ajouter :
<%@ 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. exemple de mise à jour 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. exemple de mise à jour 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. insérer insérer
<%@ 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>7. 🎜>
<%@ 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>J'espère que cet article sera utile à la programmation JSP de chacun. Pour plus d'exemples et un résumé des méthodes courantes de fonctionnement de la base de données jsp mysql et des articles connexes, veuillez faire attention au site Web PHP chinois ! /* 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;
Déclaration：
Le contenu de cet article est volontairement contribué par les internautes et les droits d'auteur appartiennent à l'auteur original. Ce site n'assume aucune responsabilité légale correspondante. Si vous trouvez un contenu suspecté de plagiat ou de contrefaçon, veuillez contacter admin@php.cn
Article précédent：Exemple de code d'opération de base de données JoomlaArticle suivant：Exemple de code d'opération de base de données Joomla
Articles Liés
Voir plus- yii2.0 Analyse des règles d'URL de lien UrlManage
- tutoriel de production de widgets yii2.0
- Explication détaillée de l'ajout, de la suppression, de la modification et de l'interrogation des opérations de la base de données Yii2.0
- Méthode d'utilisation de Yii2.0 ArrayHelper :: map ()
- méthode d'introduction de la ressource statique js css yii2.0