public void UpPpUpdate(String table,String date,int id)
{
String sql = "update "+ table +" set " + date + "where Id=?";
try
{
Mysql mysql = new Mysql(sql);
mysql.setInt(1,id);
mysql.executeUpdate();
mysql.close();
}
catch(Exception e)
{
System.out.println(e);
}
}
{
String sql = "update "+ table +" set " + date + "where Id=?";
try
{
Mysql mysql = new Mysql(sql);
mysql.setInt(1,id);
mysql.executeUpdate();
mysql.close();
}
catch(Exception e)
{
System.out.println(e);
}
}
import java.uitl.Vector;
public void insertRows(string table,Vector ids ; Vector values)
{
if(ids.size() != values.size()){
System.out.println("输入的id和value数目不等");
return;
}
if(ids.size() == 0 || values.size() ==0 ){
System.out.println("为发现要插入的字段或值");
return;
}
String sql = "insert into "+ table +" (";
for( int i =0 ; i< ids.size() ; i ++ ){
if(i ==0 )
sql = sql + ids.elementAt(i);
else
sql = sql + "," + ids.elementAt(i) ;
}
sql = sql + ") values(";
for( int j =0 ; j< values.size() ; j++){
if( j ==0)
sql = sql + "'" + values.elementAt(j) + "'";
else
sql = sql + ",'" + values.elementAt(j) + "'";
}
sql = sql + ")";
try
{
Mysql mysql = new Mysql(sql);
mysql.executeUpdate();
mysql.close();
}
catch(Exception e)
{
System.out.println(e);
}
}
public void insertRows(string sql)
{
try
{
Mysql mysql = new Mysql(sql);
mysql.setInt(1,id);
mysql.executeUpdate();
mysql.close();
}
catch(Exception e)
{
System.out.println(e);
}
}
都采取些什么模式?不然的话对每一张表都写一个添加、删除、修改、得到详细信息的bean是多么复杂啊!
对Query和Update分别写一个方法,用完整的sql语句作为参数
<%@ taglib uri="/WEB-INF/tlds/database.tld" perfix="database" %>
<database:query id="select" scope="page">
select * from table1(主体内容)
</database:query>
这样你想怎么操作数据库的时候只要更改主体内容和一些scope和id的参数,具体看你怎么设计了。
import java.sql.*;
/**
* Title:ÓÃJavabeanÁ¬½ÓÊý¾Ý¿â
* Description:ÓÃBean°Ñ³£ÓõÄÊý¾Ý¿â¹¦ÄÜ·â×°£¬ÔÚJSPÖÐÉùÃ÷¸ÃBean¡£
* Copyright: Copyright (c) 2001
* Company:¼«ËÙÍøÂçС×é
* ±àÕߣº¼«ËÙÍøÂçС×é
* version 1.0
*/
public class sql_data
{
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:guestbook";
Connection conn = null;
ResultSet rs = null; public sql_data()
{
try
{
class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.out.println("sql_data:"+e.getMessage());
}
}
public void executeInsert(String sql)
{
try
{
conn = DriverManager.getConnection(sConnStr);
Statement stmt = conn.createStatement();
stmt.executeUpdate(sql);
}
catch(SQLException e)
{
System.out.println("sql_data.executeUpdate:"+e.getMessage());
}
}
public ResultSet executeQuery(String sql)
{
rs = null;
try
{
conn = DriverManager.getConnection(sConnStr);
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException e)
{
System.out.println("executeQuery :"+e.getMessage());
}
}
public void executeDelete(String sql)
{
try
{
conn=DriverManager.getConnection(sConnStr);
Statement stmt=conn.createStatement();
stmt.executeUpdate(sql);
}
catch(SQLException ex)
{
System.err.println("sql_data.executeDelete:"+ex.getMessage());
}
}
}
//2¡¢ÔÚJSPÖÐÉùÃ÷Bean£º <jsp:useBean id="sqlbean" scope="session" class="test.sql_data"/>
<%!String sql,name;%>
<%
sql="select * from table";
ResultSet rs=sqlbean.executeQuery(sql);
while(rs.nex()){
name=rs.getString("name")
}
%>
¡­¡­
name:<%=name%>
¡­¡­
<%
rs.close();
%>
¡­¡­¡¡
import java.sql.*; public class sql_data
{
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:guestbook";
Connection conn = null;
ResultSet rs = null; public sql_data()
{
try
{
class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.out.println("sql_data:"+e.getMessage());
}
}
public void executeInsert(String sql)
{
try
{
conn = DriverManager.getConnection(sConnStr);
Statement stmt = conn.createStatement();
stmt.executeUpdate(sql);
}
catch(SQLException e)
{
System.out.println("sql_data.executeUpdate:"+e.getMessage());
}
}
public ResultSet executeQuery(String sql)
{
rs = null;
try
{
conn = DriverManager.getConnection(sConnStr);
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException e)
{
System.out.println("executeQuery :"+e.getMessage());
}
}
public void executeDelete(String sql)
{
try
{
conn=DriverManager.getConnection(sConnStr);
Statement stmt=conn.createStatement();
stmt.executeUpdate(sql);
}
catch(SQLException ex)
{
System.err.println("sql_data.executeDelete:"+ex.getMessage());
}
}
} <jsp:useBean id="sqlbean" scope="session" class="test.sql_data"/>
<%!String sql,name;%>
<%
sql="select * from table";
ResultSet rs=sqlbean.executeQuery(sql);
while(rs.nex()){
name=rs.getString("name")
}
%>
¡­¡­
name:<%=name%>
¡­¡­
<%
rs.close();
%>
¡­¡­¡¡