Javabean

来源：互联网发布：2016年四川旅游数据编辑：程序博客网时间：2024/05/18 11:14

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");