dataprocess.java

这是基于jsp的任务管理系统

/*
 * 创建日期 2005-5-1
 *
 * TODO 要更改此生成的文件的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
package cn.project.bit.DBQuery;

/**
 * @author ligang
 *
 * TODO 要更改此生成的类型注释的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
import java.sql.*;

public class DataProcess {
	
	 DataProcess(){
		
	}
	
	public static Connection getConnection()
	{
		String CLASSFORNAME="org.gjt.mm.mysql.Driver";		  

		String SERVANDDB = "jdbc:mysql://localhost:3306/project?user=root&password=123456&useUnicode=true&characterEncoding=gb2312";
										
		
		Connection con;
		
		try
		{
			Class.forName(CLASSFORNAME);
			
			con = DriverManager.getConnection(SERVANDDB);
			
			return con;
		}
		catch(Exception e)
		{
			e.printStackTrace();
			
			return null;
		}

	}
	
	public static int nCount(String SQL)
	{
		Connection myConnection = getConnection();
		

		int count = 0;
		
		try
		{
			Statement stm = myConnection.createStatement();
			
			ResultSet result = stm.executeQuery(SQL);
			
			if(result.next())
			{
				count = result.getInt(1);
				
				result.close();
			}
			
			stm.close();
			
			myConnection.close();
			
		}		
		catch(Exception e)
		{
			e.printStackTrace();
		}
		
		return count;
	}
	
	/**插入或删除语句*/
	public static void ExeQuery(String SQL)
	{
		Connection con = getConnection();
		try
		{
			Statement stmt = con.createStatement();
			
			stmt.executeUpdate(SQL);
			
			stmt.close();
			
			con.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	
	public static ResultSet getResult(String SQL,Connection con)
	{		
		ResultSet rs = null;
		
		try{
			Statement stmt = con.createStatement();
			
			rs = stmt.executeQuery(SQL);
			
		}catch(SQLException e)
		{
			e.printStackTrace();
		}
		
		return rs;
		
	}
	
	public static void CloseConnection(Connection con)
	{
		try
		{
			con.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	
	public static void CloseResultSet(ResultSet rs)
	{
		try
		{
			rs.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}

}