sqlutil.java

博客系统很好用的 适合毕业设计呵呵希望对大家有帮祝

package org.myblog.util;

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

public class SQLUtil {
	private Connection conn;
	public SQLUtil(){
		try{
			Class.forName("com.mysql.jdbc.Driver");
		}catch(ClassNotFoundException e){
			System.out.println("加载MYSQL驱动失败！");
			conn=null;
		}
		try{
			String url="jdbc:mysql://localhost:3306/myblog?useUnicode=true&characterEncoding=UTF-8";
			String user="root";
			String paw="1001";
			conn=DriverManager.getConnection(url,user,paw);
		}catch(Exception e){
			System.out.println("连接数据库失败！");
			conn=null;
		}
	}
	public ResultSet executeQuery(String sql){
		Statement stmt = null;
		ResultSet rs;
		try{
			stmt = conn.createStatement();
			rs = stmt.executeQuery(sql);
		}catch(SQLException e){
			System.out.println("查询失败");
			e.printStackTrace();
			return null;
		}
		return rs;
	}
	public void executeUpdate(String sql){
		Statement stmt = null;
		try{
			stmt = conn.createStatement();
			stmt.executeUpdate(sql);
		}catch(SQLException e){
			System.out.println("操作失败");
			e.printStackTrace();
		}
	}
	//test main
	public static void main(String args[]){
		SQLUtil su = new SQLUtil();
		String sql = "select * from user";
		ResultSet rs = su.executeQuery(sql);
		try{
		if(rs.next()){
			System.out.println(rs.getString(2));
		}
		}catch(SQLException e){
			e.printStackTrace();
		}
	}
}