Java链接数据库及操作数据库的JavaBean

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script><script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

 链接数据库：

//  Java Document
package  leeWebDemo1;
import  java.sql. * ;
public   class  DBLink
{
     private   static  Connection conn;
     private  Statement stmt;
     private  ResultSet rs;
     private   static   final  String mysqlDriver = " com.mysql.jdbc.Driver " ;
      private   static   final  String url = " jdbc:mysql://localhost:3306/mysql?user=root&password=123456 " ;
     
     public   static   synchronized  Connection getConn()  throws  Exception
    {
          try
        {
            Class.forName(mysqlDriver);
            conn = DriverManager.getConnection(url);
             return  conn;
        }
         catch (SQLException e)
        {    
            System.err.println(e.getMessage());
            System.err.println(e.getMessage());
            System.err.println( " 加载驱动失败！ " );
             throw  e; 
        }
    }
    
     // 获取Statement 只用于查询语句
     public  Statement getStmtread()
    {
         try
        {
            conn = getConn();
            stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
             return  stmt;
            
        }
        
         catch (Exception e)
        {
            System.err.println(e.getMessage());
            e.printStackTrace();
        }
        
         return   null ;
    }
    
     // 获取ResultSet
    
     public  ResultSet getRs(String sql)
    {    
         try
        {
            stmt = getStmtread();
            rs = stmt.executeQuery(sql);
             return  rs;
        }
        
         catch (Exception e)
        {
            System.err.println(e.getMessage());
            e.printStackTrace();
        }
         return   null ;
    }        
    
    
    
    
     // 获取statement 与上面的getStmtread不同用于删除、更新和添加的SQL语句；
     public  Statement getStmt()
    {
         try
        {
            conn = getConn();
            stmt = conn.createStatement();
             return  stmt;
            
        }
         catch (Exception e)
        {
            System.err.println(e.getMessage());
            e.printStackTrace();
        }
        
         return   null ;
        
    
    }
    
    
     // 关闭数据库
     public   synchronized   void  close()
    {
         try
        {
             if (rs != null )
            rs.close();
            rs = null ;
        }
         catch (Exception e)
        {
            System.err.println(e.getMessage());
            e.printStackTrace();
        }
        
         try
        {
             if (stmt != null )
            {
                stmt.close();
                stmt = null ;
            }
        
        }
        
         catch (Exception e)
        {
            System.err.println(e.getMessage());
            e.printStackTrace();
        }
            
         try
        {
             if (conn != null )
            {
                conn.close();
                conn = null ;
            }
        }
         catch (Exception e)
        {
            System.err.println(e.getMessage());
            e.printStackTrace();
        }
        
        
                

    }
    
 
    
    
    
    
    
    
    
    
    
    

}

操作数据库

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script><script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

 

//  本JavaBean包括数据的插入、更新、删除和查询等。

package  leeWebDemo1.database;
import  java.sql. * ;

public   class  DBUtil
{
     private  DBLink dblink = new  DBLink();
     private  Statement stmt;
     private  ResultSet rs;  
    

     // 获取查询的行数：没有结果返回-1，查询异常返回-2；
 
     public   int  getRowCount(String strSql)
    {
         int  intCount = 0 ;
         try {
            
            stmt = dblink.getStmtread();
            rs = stmt.executeQuery( " SELECT COUNT(*) FROM " + strSql);
             if (rs.next())
            {
                intCount = rs.getInt( 1 );
            }
             else  intCount =- 1 ; 
        }
         catch (Exception e)
        {
            intCount =- 2 ; 
        }
         finally
        {
            dblink.close();
             return  intCount;
        }
    }
    
     // 执行插入操作 
     public   int  insert(String strSql)
    {
         int  count = 0 ;
        stmt = dblink.getStmt();
         try
        {
            count = stmt.executeUpdate(strSql);
     
        }
         catch (Exception e)
        {
            count =- 2 ;
            System.err.println(e.getMessage());
            e.printStackTrace();
        }
         finally
        {
            
        dblink.close();
         return  count;
        }
    
    }
    
     // 更新数据库数据
     public   int  update(String sql)
    {
         int  count = 0 ;
        stmt = dblink.getStmt();
         try
        {
            count = stmt.executeUpdate(sql);
        }
         catch (Exception e)
        {
            count =- 2 ;
            System.err.print(e.getMessage());
            e.printStackTrace();
        }
         finally
        {
            dblink.close();
             return  count;
        }
    
    }
    
    
     // 删除数据库数据
    
     public   int  delete(String sql)
    {
         int  count = 0 ;
        stmt = dblink.getStmt();
         try
        {
            count = stmt.executeUpdate(sql);
      
        }
        
         catch (Exception e)
        {
            count =- 2 ;
            System.err.println(e.getMessage());
            e.printStackTrace();
        
        }
        
         finally
        {
            dblink.close();
             return  count;
        }
        
    
    
    }
    
    
    
    
    
    
    
    
    
    
    
}