jdbclogin.java

来自「登录页面保护(通过jsp调用servlet实现页面保护」· Java 代码 · 共 41 行

package com;
import java.sql.*;
public class JdbcLogin
{
	private Connection con=null;
	private Statement stmt=null;
	private ResultSet rs;
	public void openJdbc()
	{
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			String url="jdbc:odbc:login";
			con=DriverManager.getConnection(url,"sa","");
			stmt=con.createStatement();
			
		}catch(Exception e)
		{
			e.getStackTrace();
		}
	}
	public ResultSet selectJdbc(String sql)
	{
		try{
			rs=stmt.executeQuery(sql);
		}catch(Exception e)
		{
			e.getStackTrace();
		}
		return rs;
	}
	public void closeJdbc()
	{
		try{
			stmt.close();
			con.close();
		}catch(Exception e)
		{
			e.getStackTrace();
		}
	}
}