JavaBean实现连接数据库，数据更新查询的功能

  此页代码旨在编码一些Javabean功能以实现在jsp页面里一些功能的简化代码。

实现代码：mysqlcon.java

package wang;

import java.sql.*;

public class mysqlcon {
	public Connection con = null;
	public Statement st = null;
	public ResultSet rs = null;
	private static String drivername = "com.mysql.jdbc.Driver";
	private static String URL ="jdbc:mysql://localhost:3306/（库名）?useUnicode=true&characterEncoding=UTF8";
	private static String USER_NAME = "（用户名）";
	private static String PASSWORD = "（密码）";
	
	public static Connection getcon(){
		Connection con = null;
	  try{
		  Class.forName(drivername);
	   con = DriverManager.getConnection(URL,USER_NAME,PASSWORD);
	   System.out.println("数据库连接成功");
	  }catch(Exception e){
		  e.printStackTrace();
		  System.out.println("数据库连接失败");
	  }
	  return con; 
	  }
	
    public ResultSet search(String sql)
    {      
       try{con=getcon();
    	   st=con.createStatement();
           rs=st.executeQuery(sql);}
    	catch(Exception e){
    		 System.out.println("查询失败");
    		 e.printStackTrace();}
    	finally{return rs;}}
	
    public int update(String sql)
    {   int result=0;   
       try{con=getcon();
    	   st=con.createStatement();
           result=st.executeUpdate(sql);}
    	catch(Exception e){
    		 System.out.println("查询失败");
    		 e.printStackTrace();
    		 result=0;}
       return result;}
    
    
    
    
    
    
}