conndb.java

来自「该网上论坛除了包含数据库之外,还有能够成功地进行信息上传及返回」· Java 代码 · 共 46 行

package JavaBean;

import java.sql.*;

public class connDB{
		Connection conn=null;
		Statement stmt=null;
		ResultSet rs=null;

	public connDB(){
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}catch(java.lang.ClassNotFoundException e){
			System.err.println(e.getMessage());
		}
	}
	public ResultSet executeQuery(String sql){
		try{
	        String url="jdbc:odbc:forum"; 
	        String user = "sony";
	        String password = "sony";
			conn=DriverManager.getConnection(url,user,password);
			stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			rs=stmt.executeQuery(sql);
		}catch(SQLException ex){
			System.err.println(ex.getMessage());
			}
		return rs;
	}
	public int executeUpdate(String sql){
		int result=0;
		try{
			String url="jdbc:odbc:wsbmy"; 
	        String user = "sony";
	        String password = "sony";
			conn=DriverManager.getConnection(url,user,password);
			stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			result=stmt.executeUpdate(sql);
		}catch(SQLException ex){
			result=0;
			}
		return result;
	}

}