meeting.java

基于WEB的会议管理系统

package com.meet.bean;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.lang.*;;

public class meeting {
    
	private String dbDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
	private String      url = "jdbc:odbc:meeting";	
	private String     user = "sa";
	private String password = "";
	
	private Connection conn  ;
	private Statement    st  ;
	private ResultSet    rs  ;
	
	public meeting(){ 
		try {
			Class.forName(dbDriver);
			conn = DriverManager.getConnection(url, user, password);
			System.out.println("success");
		}catch (ClassNotFoundException e) {
			e.printStackTrace();
		}catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
   public  ResultSet executeFind(String sql)
   {
	   try {			
			st = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
			rs = st.executeQuery(sql);
		
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return rs;
   }
	/*
	 * **
	 * SQL更新方法,返回更新的记录数
	 * @param  sql
	 * @return int
	 */
	public int executeUpdate(String sql) { 
		int i = 0;
		try {			
			st = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
			i = st.executeUpdate(sql);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return i;

	}
	 public String codeToString (String str) 
	    {
	        String s=str;
	        try
	         {   byte tb[]=s.getBytes("iso-8859-1");
	             s=new String (tb);
	             return s;
	          }
	         catch(Exception e)
	          {  e.printStackTrace();}
	         return s;
	    } 

	 
}