jdbcconnection.java

JSP数据库连接的JAVABEAN代码

package com.tool;

import java.sql.*;
import java.io.*;
import java.util.*;
import java.text.*;

public class JDBCconnection {
	private final static String dbDriver="sun.jdbc.odbc.JdbcOdbcDriver";
	private final static String url="jdbc:odbc:newsSQLServer";
	private final static String userName="sa";
	private final static String password="";
	private Connection con =null;

public JDBCconnection(){
	try{
		Class.forName(dbDriver).newInstance(); //加载数据库驱动
	}catch(Exception ex){
		
	}
}

public boolean creatConnection(){               //创建数据库连接
	try{
		con=DriverManager.getConnection(url,userName,password);
		con.setAutoCommit(true);
	}catch(SQLException e){
	}
	return true;
}

public boolean insertImage(String Filesroot,int newsID) throws Exception{
	if(con==null){
			creatConnection();
		}
		
	try{
	FileInputStream str=new FileInputStream(Filesroot);
	Statement stmt=con.createStatement();
	
	String sql="insert into news_pic (img,newsID,mark) values(?,?,?)";
	PreparedStatement pstmt=con.prepareStatement(sql);
	pstmt.setBinaryStream(1,str,str.available());
	pstmt.setInt(2,newsID);
	pstmt.setString(3,"1");
	pstmt.execute();
	return true;
	}catch(SQLException e){
			return false;
		}
	}

public boolean executeUpdate(String sql){         //增加，修改，删除操作
	if(con==null){
		creatConnection();
	}
	try{
		Statement stmt=con.createStatement();
		int iCount=stmt.executeUpdate(sql);
		return true;
	}catch(SQLException e){
		return false;
	}
}

public ResultSet executeQuery(String sql){        //对数据库的查询操作
	ResultSet rs;
	try{
		if(con==null){
			creatConnection();
		}
		Statement stmt=con.createStatement();
		try{
			rs=stmt.executeQuery(sql);
		}catch(SQLException e){
			return null;
		}
	}catch(SQLException e){
		return null;
	}
	return rs;
}

public void closeConnection(){
	if(con!=null){
		try{
			con.close();
		}catch(SQLException e){
			e.printStackTrace();
		}finally{
			con=null;
		}
	}
}
}