usersql.java

本系统对学生信息操作控制流程和相关数据信息进行了较为全面且科学高效的管理

package mypackage;
import conn.DataBaseConnection;
import java.sql.*;
import java.util.*;
import java.io.*;

public class UserSql
{
  	    private ResultSet rs=null;
  	    private Statement stmt=null;
  	    private Connection con=null;
  	    public UserSql()
  	    {
  	    	this.con=DataBaseConnection.getConnection();
  	    }
  	    public ResultSet executeQuery(String sql)
  	    {
  	    	try{
  	    	    stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
  	    		rs=stmt.executeQuery(sql);
  	    
  	    	}catch(SQLException ex)
  	    	{
  	    		System.err.println(ex.getMessage());
  	    	}
  	    	
  	    	return rs;
  	    }
  	    
  	    public int executeUpdate(String sql)
  	    {
  	    	int count=0;
  	    	try{
  	    		stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
  	    		count=stmt.executeUpdate(sql);
  	    	
  	    	}catch(SQLException ex)
  	    	{
  	    		System.err.println(ex.getMessage());
  	    	}
  	         
  	    	return count;

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