conn.java

是一个JSP与数据库应用系统

package database;

import java.sql.*;

public class conn
{
	String DbDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
	String Url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=C_News";
	String User = "sa";
	String Password = "chen123";
	
	Connection conn = null;
	Statement stmt = null;
    ResultSet rs = null;
    
    public conn()
    {
    	try
    	{
    		Class.forName(DbDriver).newInstance(); 
    	}
    	catch(Exception e)
    	{
    		e.printStackTrace();
    	}
    }
    
    public ResultSet executeQuery(String strsql)
    {
    	try
    	{
    		conn = DriverManager.getConnection(Url,User,Password);
    		stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
    		rs = stmt.executeQuery(strsql);
    		
    	}
    	catch(Exception e)
    	{
    		e.printStackTrace();
    	}
    	return rs;
    }
    
    public void executeInsert(String strsql)
    {
    	try
    	{
    		conn = DriverManager.getConnection(Url,User,Password);
    		stmt = conn.createStatement();
    		stmt.executeUpdate(strsql);
    		stmt.close();
    		conn.close();
    	}
    	catch(Exception e)
    	{
    		e.printStackTrace();
    	}
    }
    
    public void executeUpdate(String strsql)
    {
    	try
    	{
    		conn = DriverManager.getConnection(Url,User,Password);
    		stmt = conn.createStatement();
    		stmt.executeUpdate(strsql);
    		stmt.close();
    		conn.close();
    	}
    	catch(Exception e)
    	{
    		e.printStackTrace();
    	}
    }
    
    public void executeDelete(String strsql)
    {
    	try
    	{
    		conn = DriverManager.getConnection(Url,User,Password);
    		stmt = conn.createStatement();
    		stmt.executeUpdate(strsql);
    		stmt.close();
    		conn.close();
    	}
    	catch(Exception e)
    	{
    		e.printStackTrace();
    	}
    }
    
    public void closestmt()
    {
    	try
    	{
    		stmt.close();
    	}
    	catch(Exception e)
    	{
    		e.printStackTrace();
    	}
    }
    
    public void closeconn()
    {
    	try
    	{
    		conn.close();
    	}
    	catch(Exception e)
    	{
    		e.printStackTrace();
    	}
    }
	
	
	
	public static void main(String[] args)
	{
		System.out.println("success");
	}
}