不用Bean,直接调用class的方法
如:AaClass a=new AaClass();
a.do(ParamterList);
如:AaClass a=new AaClass();
a.do(ParamterList);
解决方案 »
- SQL2000查询2表的问题
- 要的是jakarta-tomcat-4.1.27.exe下载下来的是apache-tomcat-4.1.39.exe
- java 接口中写抽象方法有什么好处
- 为什么我的数据少了一条?
- 做过地图的大哥请给小弟点指点
- servlet中实现文件上传问题
- session是不是挺费资源的!?
- java.lang.NegativeArraySizeException,怎么解决阿?
- 关于Tomcat兼容性问题的请教
- 谁能帮帮我,我急用啊!!只有这么多了,全给!
- asp的变量传到jsp里面
- (急得要命!)oracle数据库表中某一LONG字段内容是word类型的文档(ole形式嵌入),如何取出该字段内嵌的word文档内容?
int aa;
public void doAa(ParamList){
...
}
}JSP页面:
<%@ page import="AaClass"%>
<%
AaClass a=new AaClass();
a.doAa(ParamterList);
%>
import java.sql.*;public class DataBean{
Connection conn=null;
//初始化,连接数据库
public DataBean(){
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn= DriverManager.getConnection("jdbc:odbc:dsn1", "sa", "");
}
catch(Exception e){
}
}
//关闭连接
public void CloseConnection(){
try{
conn.close();
}
catch(Exception e){}
}
//添加记录
public String AddRecord(String TableName,String FieldName,String FieldValue){
String str="";
try{
String sql="insert into "+TableName+"("+FieldName+")values("+FieldValue+")";
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
stmt.executeUpdate(sql);
stmt.close();
str="OK";
}
catch(Exception e){
str= e.toString();
}
return str;
}
//更新记录
public String UpdateRecord(String TableName,String FieldStr,String WhereStr){
String str="";
try{
String sql="update "+TableName+" set "+FieldStr+" where "+WhereStr;
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
stmt.executeUpdate(sql);
stmt.close();
str="OK";
}
catch(Exception e){
str= e.toString();
}
return str;
}
//删除记录
public String DeleteRecord(String TableName,String WhereStr){
String str="";
try{
String sql="delete from "+TableName+" where "+WhereStr;
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
stmt.executeUpdate(sql);
stmt.close();
str="OK";
}
catch(Exception e){
str= e.toString();
}
return str;
} //获取记录
public ResultSet GetRs(String TableName,String FieldName,String WhereStr,String OrderStr,String SortStr){
String sql = "";
String FieldName1="";
String SortStr1="";
ResultSet resultset=null;
try{
if(FieldName=="")
FieldName1="*";
else
FieldName1=FieldName;
if(SortStr!="desc")
SortStr1="asc";
else
SortStr1="desc";
sql="select "+FieldName1+" from "+TableName+" where "+WhereStr;
sql=sql+" Order by "+OrderStr+" "+SortStr1;
Statement statement = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
resultset = statement.executeQuery(sql);
}
catch(Exception exception){
resultset=null;
}
return resultset;
}
}
所言即是