Javabean

package mysql_conn;

import java.sql.*;

public class mysqlconn

{

       public mysqlconn(){

  

  }

 

  private Connection conn = null;

  private ResultSet  result = null;

  private Statement  sttm = null;

  private String     server = "127.0.0.1";

  private String     port = "3306";

       private String     driver="com.mysql.jdbc.Driver";

  private String     user ="root";

  private String     pass ="lingting";

  private String     dbname = "utftest";

  private String     URL="jdbc:mysql://"+server+":"+port+"/"+dbname+"?useUnicode=true&characterEncoding=UTF-8&user="+user+"&password="+pass;

 

  public Connection mysql_conn(){

      try

      {

 Class.forName(driver).newInstance();

 conn = DriverManager.getConnection(URL);

      }

      catch (Exception e)

      {

  e.printStackTrace();

      }

  return conn;

  }

 

  public ResultSet mysql_query(String str){

      try

      {

 Statement sttm=conn.createStatement();

 result = sttm.executeQuery(str);

      }

      catch (Exception e)

      {

                e.printStackTrace();

      }

  return result;

  }

 

  public void mysql_update(String up_str){

      try{

       Statement sttm=conn.createStatement();

sttm.executeUpdate(up_str);

  }catch(SQLException ex){

       System.err.println("mysql_update():"+ex.getMessage());

  }

  }

 

 

 

 

     public void conn_close(){
           try{
               if(conn!=null)
                conn.close();
               if(sttm!=null)
                sttm.close();
               if(rs!=null)
                   rs.close();
           }catch(Exception e){
                e.printStackTrace();
           }
       }

}

 

 

通过以下程序可以调用这个javabean

 

 

<jsp:useBean id="Border" scope="page" class="conn.mysqlconn" />

 

<%

ResultSet rs = null;

Connection conn = null;

conn = Border.mysql_conn() ;

rs = Border.mysql_query("select * from cheng order by id DESC");

%>