querybean.java

来自「该源码为JSP的开发案例集锦」· Java 代码 · 共 43 行

package ch4;

import java.sql.*;
public class QueryBean{ 
	private Connection conn=null;
	private ResultSet rs=null; 
    	String dbUrl = "jdbc:mysql://localhost/csnews";
	String dbUser = "root";
 	String dbPassword = "";

	public QueryBean(){ 
		try {
			Class.forName("org.gjt.mm.mysql.Driver"); 
		}
		catch(java.lang.ClassNotFoundException e) {
			System.err.println( e.getMessage());
		}
	}
 
	public ResultSet getQuery(String sqls){ 
		try{ 
			conn = DriverManager.getConnection(dbUrl,dbUser,dbPassword); 
			Statement statement=conn.createStatement();
			rs=statement.executeQuery(sqls); 
		}
		catch(Exception e){
			System.out.println(e.toString());
		} 
		return rs; 
   	} 

	public void setModify(String sqls){ 
		try{ 
			conn = DriverManager.getConnection(dbUrl,dbUser,dbPassword); 
			Statement statement=conn.createStatement(); 
			statement.executeUpdate(sqls); 
		} 
		catch(Exception e){ 
			System.out.println(e.toString()); 
		} 
   	} 

}