usersql.java

JSP开发的学生信息管理系统

// 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:   UserSql.java

package mypackage;

import java.io.PrintStream;
import java.sql.*;

// Referenced classes of package mypackage:
//			DataBaseConnection

public class UserSql
{

	private ResultSet rs;
	private Statement stmt;
	private Connection con;

	public UserSql()
	{
		rs = null;
		stmt = null;
		con = null;
		con = DataBaseConnection.getConnection();
	}

	public ResultSet executeQuery(String s)
	{
		try
		{
			stmt = con.createStatement(1005, 1008);
			rs = stmt.executeQuery(s);
		}
		catch (SQLException sqlexception)
		{
			System.err.println(sqlexception.getMessage());
		}
		return rs;
	}

	public int executeUpdate(String s)
	{
		int i = 0;
		try
		{
			stmt = con.createStatement(1005, 1008);
			i = stmt.executeUpdate(s);
		}
		catch (SQLException sqlexception)
		{
			System.err.println(sqlexception.getMessage());
		}
		return i;
	}

	public void close()
	{
		try
		{
			stmt.close();
			con.close();
		}
		catch (SQLException sqlexception)
		{
			sqlexception.printStackTrace();
		}
	}
}