国内精品在线播放,激情久久婷婷,久久尤物视频

主頁 > 知識庫 > jsp+mysql數據庫操作常用方法實例總結

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">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>考生數據/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>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. 創建數據庫

/*
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程序設計有所幫助。

您可能感興趣的文章:

國內常用的js類庫大全(CDN公共庫)
Java幾種常用JSON庫性能比較詳解
Python常用的json標準庫
常用的9個JavaScript圖表庫詳解
JSP中操作數據庫的常用SQL標簽用法總結
JavaScript 常用函數庫詳解
簡單了解常用的JavaScript 庫

標簽：西藏紅河丹東云浮江西宿州貴州青島

巨人網絡通訊聲明：本文標題《jsp+mysql數據庫操作常用方法實例總結》，本文關鍵詞 jsp+mysql,數據庫,操作,常用,；如發現本文內容存在版權問題，煩請提供相關信息告之我們，我們將及時溝通與處理。本站內容系統采集于網絡，涉及言論、版權與本站無關。

婷婷综合国产,91蜜桃婷婷狠狠久久综合9色 ,九九九九九精品,国产综合av

jsp+mysql數據庫操作常用方法實例總結