本文實例講述了jsp+mysql數(shù)據(jù)庫操作常用方法。分享給大家供大家參考。具體如下:
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>考生數(shù)據(jù)/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">nbsp;/td> td width="42" wnameth="50">Input type="reset" name="h" value="重置">/td> td width="33" wnameth="42">nbsp;/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>考生數(shù)據(jù)/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>無標(biāo)題文檔/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>nbsp; /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="修改">nbsp; nbsp; nbsp;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. 創(chuàng)建數(shù)據(jù)庫
/* 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程序設(shè)計有所幫助。
標(biāo)簽:西藏 紅河 丹東 云浮 江西 宿州 貴州 青島
巨人網(wǎng)絡(luò)通訊聲明:本文標(biāo)題《jsp+mysql數(shù)據(jù)庫操作常用方法實例總結(jié)》,本文關(guān)鍵詞 jsp+mysql,數(shù)據(jù)庫,操作,常用,;如發(fā)現(xiàn)本文內(nèi)容存在版權(quán)問題,煩請?zhí)峁┫嚓P(guān)信息告之我們,我們將及時溝通與處理。本站內(nèi)容系統(tǒng)采集于網(wǎng)絡(luò),涉及言論、版權(quán)與本站無關(guān)。上一篇:JSP文件下載功能的4種方法