各位大G大J:
我现在在做一个小网站,必须使用Struts,我自己写了一个连接数据库用的Bean,但是感觉不太好,这个是我的代码:
import java.sql.*;public class JavaSqlBean {
private Connection con = null;
private Statement stmt = null;
private PreparedStatement pstmt = null;
private CallableStatement cstmt = null;
private ResultSet rst = null; public JavaSqlBean(){
} public void setConnection(Connection con) {
this.con = con;
} public Connection getConnection() {
return con;
} public void setStatement(Statement stmt) {
this.stmt = stmt;
} public Statement getStatement() {
return stmt;
} public void setPreparedStatement(PreparedStatement pstmt) {
this.pstmt = pstmt;
} public PreparedStatement getPreparedStatement() {
return pstmt;
} public void setCallableStatement(CallableStatement cstmt) {
this.cstmt = cstmt;
} public CallableStatement getCallableStatement() {
return cstmt;
} public void setResultSet(ResultSet rst) {
this.rst = rst;
} public ResultSet getResultSet() {
return rst;
} public void OpenJavaSql(){
String CLASSFORNAME = "com.microsoft.jdbc.sqlserver,SQLServerDriver";
String SERVANDDB = "jdbc:microsoft.sqlserver://127.0.0.1:1433;DatabaseBame=JavaSql_0704";
String USER = "";
String PWD = "";
try{
Class.forName(CLASSFORNAME);
con = DriverManager.getConnection(SERVANDDB,USER,PWD);
stmt = con.createStatement();
}catch(Exception e){
e.printStackTrace();
}
} public void JavaSqlAdd(){
try{
}catch(Exception e){
}
} public void JavaSqlDel(){
try{
}catch(Exception e){
}
} public void JavaSqlMod(){
try{
}catch(Exception e){
}
} public void JavaSqlSrch(){
try{
}catch(Exception e){
}
} public void CloseJavaSql(){
try{
rst.close();
rst = null;
cstmt.close();
cstmt = null;
pstmt.close();
pstmt = null;
stmt.close();
stmt = null;
con.close();
con = null;
}catch(Exception e){
e.printStackTrace();
}
}
}
由于我是新人,所以很想大家给我点建议,而且大家最好能给个代码我参考哈子!谢谢拉!
我现在在做一个小网站,必须使用Struts,我自己写了一个连接数据库用的Bean,但是感觉不太好,这个是我的代码:
import java.sql.*;public class JavaSqlBean {
private Connection con = null;
private Statement stmt = null;
private PreparedStatement pstmt = null;
private CallableStatement cstmt = null;
private ResultSet rst = null; public JavaSqlBean(){
} public void setConnection(Connection con) {
this.con = con;
} public Connection getConnection() {
return con;
} public void setStatement(Statement stmt) {
this.stmt = stmt;
} public Statement getStatement() {
return stmt;
} public void setPreparedStatement(PreparedStatement pstmt) {
this.pstmt = pstmt;
} public PreparedStatement getPreparedStatement() {
return pstmt;
} public void setCallableStatement(CallableStatement cstmt) {
this.cstmt = cstmt;
} public CallableStatement getCallableStatement() {
return cstmt;
} public void setResultSet(ResultSet rst) {
this.rst = rst;
} public ResultSet getResultSet() {
return rst;
} public void OpenJavaSql(){
String CLASSFORNAME = "com.microsoft.jdbc.sqlserver,SQLServerDriver";
String SERVANDDB = "jdbc:microsoft.sqlserver://127.0.0.1:1433;DatabaseBame=JavaSql_0704";
String USER = "";
String PWD = "";
try{
Class.forName(CLASSFORNAME);
con = DriverManager.getConnection(SERVANDDB,USER,PWD);
stmt = con.createStatement();
}catch(Exception e){
e.printStackTrace();
}
} public void JavaSqlAdd(){
try{
}catch(Exception e){
}
} public void JavaSqlDel(){
try{
}catch(Exception e){
}
} public void JavaSqlMod(){
try{
}catch(Exception e){
}
} public void JavaSqlSrch(){
try{
}catch(Exception e){
}
} public void CloseJavaSql(){
try{
rst.close();
rst = null;
cstmt.close();
cstmt = null;
pstmt.close();
pstmt = null;
stmt.close();
stmt = null;
con.close();
con = null;
}catch(Exception e){
e.printStackTrace();
}
}
}
由于我是新人,所以很想大家给我点建议,而且大家最好能给个代码我参考哈子!谢谢拉!
String CLASSFORNAME = "com.microsoft.jdbc.sqlserver,SQLServerDriver";
String SERVANDDB = "jdbc:microsoft.sqlserver://127.0.0.1:1433;DatabaseBame=JavaSql_0704";
String USER = "";
String PWD = "";
try{
Class.forName(CLASSFORNAME);
con = DriverManager.getConnection(SERVANDDB,USER,PWD);
stmt = con.createStatement();
}catch(Exception e){
e.printStackTrace();
}
}这些信息最好从一个外部文件中获取
JavaSqlAdd一直到JavaSqlSrch这几个空方法,你可以做成抽象方法,由子类来实现。
或者你将在内部实现其statement到SQL操作,而客户端在调用时候只需要setStamentment等信息就可以完成这次SQL操作。