db.java

类似于csdn的上传下载系统

package org.adam.bean;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.sql.DataSource;

public class DB {
	Connection conn=null;
	public DB(){
		
	}
	public DB(DataSource ds){
		super();
		try {
			conn=ds.getConnection();
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
	}
	public void getConnection(){
		try{
			Class.forName("com.mysql.jdbc.Driver");
			conn=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/download","root","43046721" );
		}catch(Exception e){
			e.getMessage();
		}
	}
	public ResultSet getData(String sql){
		
		try{
			Statement stmt=conn.createStatement();
			ResultSet rs=stmt.executeQuery(sql);
			return rs;
		}catch(Exception e){
			return null;
		}
		
	}
	public void Insert(String sql){				
		try {			
			Statement stmt=conn.createStatement();
			stmt.executeUpdate(sql);
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
	}
	public void closed(){
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
	}
	public ResultSet useAjax(String sql){
		if(conn==null)
			getConnection();
		try{
			Statement stmt=conn.createStatement();
			ResultSet rs=stmt.executeQuery(sql);
			return rs;
		}catch(Exception e){
			return null;
		}
	}
}