jlconnection.java

一般用户可以进行留言,管理员可以进行留言的删除,查询等.

package Jlpackage;
import java.sql.*;
public class JLConnection {
	String DbDriver="sun.jdbc.odbc.JdbcOdbcDriver";
	String DbconUrl="jdbc:odbc:db_JL";
	Connection conn=null;
	Statement stmt=null;
	ResultSet rs=null;
	public ResultSet executeQuery(String sql) throws SQLException
	{
		try{
			Class.forName(DbDriver);
			conn=DriverManager.getConnection(DbconUrl);
			stmt=conn.createStatement();
			rs=stmt.executeQuery(sql);
			
			
		}
		 catch(Exception e)
		 {
			 e.printStackTrace();
		 }
		 
		 return rs;
	} 
	public int Update(String sql) throws SQLException{
		int result=0;
		try{
			Class.forName(DbDriver);
			conn=DriverManager.getConnection(DbconUrl);
			Statement mn=conn.createStatement();
			result=mn.executeUpdate(sql);
		}
		catch (Exception e){
			e.printStackTrace();
		}
		
		return result;
		
	}
	
		 

}