databaseconn.java

来自「JSP+SQL2000做的化妆品销售管理网站设计,还包含文档」· Java 代码 · 共 72 行

// Decompiled by Jad v1.5.8e2. Copyright 2001 Pavel Kouznetsov.
// Jad home page: http://kpdus.tripod.com/jad.html
// Decompiler options: packimports(3) fieldsfirst ansi space 
// Source File Name:   DatabaseConn.java

package test.db;

import java.sql.*;

public class DatabaseConn
{

	public Connection con;
	public String URL;
	public String Message;

	public DatabaseConn()
	{
		URL = "jdbc:odbc:info";
	}

	public boolean connection()
	{
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}
		catch (ClassNotFoundException ex)
		{
			Message = ex.getMessage();
			System.exit(-1);
		}
		try
		{
			con = DriverManager.getConnection(URL);
		}
		catch (SQLException ex)
		{
			Message = ex.getMessage();
			return false;
		}
		return true;
	}

	public boolean close()
	{
		try
		{
			con.close();
		}
		catch (Exception ex)
		{
			Message = ex.getMessage();
			return false;
		}
		return true;
	}

	public ResultSet exeSQL(String sqlstr)
	{
		ResultSet rs;
		connection();
		Statement stmt = con.createStatement();
		rs = stmt.executeQuery(sqlstr);
		return rs;
		Exception ex;
		ex;
		Message = ex.getMessage();
		return null;
	}
}