添加信息項目流程
1． javaBean:
a.Stu.java: public class Stu {private String name,sex,myclass; private int age;
public void setName(String nm){name=nm;} public String getName(){return name; }
b.DBContext.java: import java.sql.*;import sun.jdbc.odbc.*; public class DBContext {
public static final DBContext getInstance=new DBContext (); //靜態可共享連接
public Connection getConnection(){ try{ Class.forName("Driver");
Connection conn=DriverManager.getConnection(url,user,password);
System.out.println("連接成功！"); return conn; } //getConnection要返回個Conn類
catch(Exception e){e.printStackTrace();return null;}}}
c.DBBean.java: import java.sql.*; public class DBBean {
Connection conn=null; ResultSet rs=null;
public ResultSet executeQuery(String sql){ rs=null;
try{ conn=DBContext.getInstance.getConnection();
Statement stmt=conn.createStatement(); rs=stmt.executeQuery(sql); }
catch(SQLException ex){ex.getMessage();} return rs; }//代替方法體里面return
public int executeUpdate(String sql){
try{ conn=DBContext.getInstance.getConnection();
Statement stmt=conn.createStatement();int i=stmt.executeUpdate(sql);
if(i>0) System.out.println("update success!:"+i);
else System.out.println("update error!"); return i; }
catch(Exception ex){ ex.printStackTrace(); return -1; } }
public void closeConnection(){
try{ if(!conn.isClosed()) conn.close();}//檢索connection對象是否被關閉
catch(Exception ex){ ex.printStackTrace();} }
進行測試：public static void main(String[] args){DBBean dbo=new DBBean();
ResultSet rs=dbo.executeQuery("select *from mytalbe");
try{ while(rs.next()){if(rs.getString("name")!=null){
System.out.println(rs.getString("name").toString());}} }
catch(Exception ex){ ex.printStackTrace();}}}
2． 添加信息塊：insertStu.jsp:<%@ include file="stuManager.jsp"%>
添加測試：<jsp:useBean id="stu" scope="page" class="Stu"/>
<jsp:setProperty name="stu" property="*"/>
<jsp:useBean id="DBbean" scope="page" class=" DBBean"/>
<%String name=stu.getName();String sex=stu.getSex();int age=stu.getAge();
String myclass=stu.getMyclass();
String sql="insert into mytable(name,sex,age,myclass)
values("+"'"+name+"',"+"'"+sex+"',"+"'"+age+"',"+"'"+myclass+"'"+")";
int i=DBbean.executeUpdate(sql); if(i>0){ out.println("insert success!"); }
else{ out.println("insert error!"); }%>
3．查詢信息塊(表頭如圖)：<jsp:useBean id="DBbean" scope="page" class=" DBBean"/>
<% ResultSet rs=DBbean.executeQuery("select * from mytable"); %>
<% while(rs.next()){ %> <tr>
<td height="23"><div align="center"><%= rs.getString("name") %></div></td>
<td><div align="center"><%= rs.getString("sex") %></div></td>
<td><div align="center"><%= rs.getString("age") %></div></td>
<td><div align="center"><%= rs.getString("myclass") %></div></td>
<td><div align="center"><a href="delete.jsp?
id=<%= rs.getInt("id") %>">delete</a></div></td>
<td><div align="center"><a href="update.jsp?
id=<%= rs.getInt("id") %>">update</a></div></td>
</tr> <% } %>
4． 刪除信息塊：<jsp:useBean id="DBbean" scope="page" class=" DBBean"/>
<% String n=request.getParameter("id"); //selectStu的href(id)
String sql="delete from mytable where id='"+n+"'";
int i=DBbean.executeUpdate(sql);
if(i>0) { response.sendRedirect("selectStu.jsp");} else {out.print("失敗!");} %>
5．更新信息塊（表單如圖）：<jsp:useBean id="DBbean" scope="page" class=" DBBean"/>
<% String n=request.getParameter("id");//selectStu的href(id)
ResultSet rs=DBbean.executeQuery("select *from mytable where id='"+n+"'");
if(rs!=null) rs.next(); %>//返回到第一個記錄之上，所以一定要取next的值
測試更新(提交id)：<jsp:useBean id="DBbean" scope="page" class=" DBBean"/>
<% String name=stu.getName();String sex=stu.getSex(); int age=stu.getAge();
String myid=request.getParameter("id");String myclass=stu.getMyclass();
String sql="update mytable set name='"+name+"',sex='"+sex+"',
age='"+age+"',myclass='"+myclass+"' where id="+myid;
int i=DBbean.executeUpdate(sql);
if(i>0){ out.println("更新成功！");response.sendRedirect("selectStu.jsp"); }
else { out.print("error!");} %>