本文執行個體講述了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 TransferSource Host: localhostSource Database: studentTarget Host: localhostTarget Database: studentDate: 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程式設計有所協助。
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
