javaBean的设计规范

javaBean的设计规范：

• 一个javaBean类必须是一个公共类
• 一个javaBean类必须有一个空的构造函数
• 一个javaBean类不应有公共实例变量
• 持有值应该通过一组存取方法（getXxx和setXxx）来访问

实例：

package Show;
import java.sql.*;

public class DBconn{
    private String sDBDriver="org.gjt.mm.mysql.Driver";
    private String sConnStr="jdbc:mysql://10.1.1.79:3306/web?user=root&password=2676141";
    private Connection conn=null;
    private ResultSet rs=null;
   
 public DBconn(){
  try{
            Class.forName(sDBDriver);
        }
        catch(java.lang.ClassNotFoundException e){
            System.out.println("DBconn():"+e.getMessage());
        }
    }

 public String getsConnStr(){
  return sConnStr;
 }

 public void setsConnStr(String sConnStr){
  this.sConnStr=sConnStr;
 }
  
 public void executeUpdate(String sql)throws Exception{
  sql=new String(sql.getBytes("GBK"),"ISO8859_1");
  try{
   conn=DriverManager.getConnection(sConnStr);
            Statement stmt=conn.createStatement();
            stmt.executeUpdate(sql);
   conn.close();
   stmt.close();
        }
        catch(SQLException ex){
            System.out.println("sql.executeUpdate:"+ex.getMessage());
        }
    }
 public ResultSet executeQuery(String sql)throws Exception{
        rs=null;
  try{
            sql=new String(sql.getBytes("GBK"),"ISO8859_1");
            conn=DriverManager.getConnection(sConnStr);
            Statement stmt=conn.createStatement();
            rs=stmt.executeQuery(sql);
            conn.close();
            stmt.close();
        }
  catch(SQLException ex){
            System.out.println("sql.executeQuery:"+ex.getMessage());
        }
  return rs;
    }
}