package
myproject.database;
import java.sql. * ;
public class DB ... {
private Connection cn;
private Statement st;
private ResultSet rs;
private int up; //存储执行更新语句后的返回结果
private String error; //存储错误号
private boolean value; //存储数据库是否有结果返回true或false
public Connection getCn() ...{
return cn;
}
public Statement getSt() ...{
return st;
}
public ResultSet getRs() ...{
return rs;
}
public int getUp() ...{
return up;
}
public String getError() ...{
return error;
}
public boolean isValue() ...{
return value;
}
public void setCn(Connection cn) ...{
this.cn = cn;
}
public void setSt(Statement st) ...{
this.st = st;
}
public void setRs(ResultSet rs) ...{
this.rs = rs;
}
public void setError(String error) ...{
this.error = error;
}
public void setValue(boolean value) ...{
this.value = value;
}
public DB()...{
try...{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //加载数据库驱动
cn=DriverManager.getConnection("jdbc: odbc:test","sa","kebike"); //连接test数据源,有个空格,请各位自己去掉
st=cn.createStatement();
}catch(Exception ce)...{
error="加载驱动出错!";
}
}
/**//*--result负责执行sql语句,参数sql为要执行的语句,type为语句类型,查询或更新--*/
public void result(String sql,int type)...{
if(type==0)...{ //type为0则执行查询语句。是否有结果存储在value变量
try...{
rs=st.executeQuery(sql);
if(rs.next())...{
value=true;
error="数据库有结果返回";
}else...{
value = false;
error="数据库无结果返回";
}
}catch(SQLException ce)...{
error="查询时发生错误";
}
}
if(type==1)...{ //type为1则执行更新语句,将执行结果存储在up里,如果up大于0则说明执行成功
try...{
up=st.executeUpdate(sql);
if(up>0)
error="操作成功!";
else
error="更新结果时发生了错误";
}catch(SQLException ce)...{
error="可能是您的sql语句发生了错误";
}
}
}
}
import java.sql. * ;
public class DB ... {
private Connection cn;
private Statement st;
private ResultSet rs;
private int up; //存储执行更新语句后的返回结果
private String error; //存储错误号
private boolean value; //存储数据库是否有结果返回true或false
public Connection getCn() ...{
return cn;
}
public Statement getSt() ...{
return st;
}
public ResultSet getRs() ...{
return rs;
}
public int getUp() ...{
return up;
}
public String getError() ...{
return error;
}
public boolean isValue() ...{
return value;
}
public void setCn(Connection cn) ...{
this.cn = cn;
}
public void setSt(Statement st) ...{
this.st = st;
}
public void setRs(ResultSet rs) ...{
this.rs = rs;
}
public void setError(String error) ...{
this.error = error;
}
public void setValue(boolean value) ...{
this.value = value;
}
public DB()...{
try...{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //加载数据库驱动
cn=DriverManager.getConnection("jdbc: odbc:test","sa","kebike"); //连接test数据源,有个空格,请各位自己去掉
st=cn.createStatement();
}catch(Exception ce)...{
error="加载驱动出错!";
}
}
/**//*--result负责执行sql语句,参数sql为要执行的语句,type为语句类型,查询或更新--*/
public void result(String sql,int type)...{
if(type==0)...{ //type为0则执行查询语句。是否有结果存储在value变量
try...{
rs=st.executeQuery(sql);
if(rs.next())...{
value=true;
error="数据库有结果返回";
}else...{
value = false;
error="数据库无结果返回";
}
}catch(SQLException ce)...{
error="查询时发生错误";
}
}
if(type==1)...{ //type为1则执行更新语句,将执行结果存储在up里,如果up大于0则说明执行成功
try...{
up=st.executeUpdate(sql);
if(up>0)
error="操作成功!";
else
error="更新结果时发生了错误";
}catch(SQLException ce)...{
error="可能是您的sql语句发生了错误";
}
}
}
}