JDBC例子

这是平时链接数据库用的各种方法，为了方便自己调用而准备的

package proven;

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

public class JdbcDemo2 {

public static final String url = "jdbc:mysql://localhost:3306/jdbc?useUnicode=true&characterEncoding=UTF-8";
public static final	String username = "root";    //数据库账号
public static final String password = "";        //数据库密码（每个人应该都不同）

public static Connection conn =null;
public static Statement stmt = null;
public static ResultSet rs = null;

//安装驱动
static{
	try {
		Class.forName("com.mysql.jdbc.Driver");
		conn = DriverManager.getConnection(url,username,password);
		if(conn!=null){
			System.out.println("数据库连接正常");
		}else{
			System.out.println("数据库连接失败");
		}
	} catch (Exception e) {
		e.printStackTrace();
	}
}

//查询方法
public static void query(){
	try {
		stmt = conn.createStatement();
		String sql = "select * from user;";
		rs = stmt.executeQuery(sql);
		
		while(rs.next()){
			System.out.println("ID"+rs.getInt("id")+"  姓名："+rs.getString("name")+"  密码："+rs.getString("pwd"));
		}
	} catch (SQLException e) {
		e.printStackTrace();
	}
	finally{
		relaseResourse();
		
	}
	
}

//释放资源
public static void relaseResourse(){
	try {
		if(rs!=null){
			rs.close();
			rs = null;
		}
		if(stmt!=null){
			stmt.close();
			stmt = null;
		}
		if(conn!=null){
			conn.close();
			conn=null;
		}
	} catch (Exception e) {
		e.printStackTrace();
	}
	
}
 //增加数据操作
public static void add(){
	try {
		stmt = conn.createStatement();
		String sql ="insert into user values(null,'abcd','123')";
	    int result = stmt.executeUpdate(sql);
	    if(result>0){
	    	System.out.println("添加数据成功");
	    }else{
	    	System.out.println("添加数据失败");
	    }
	} catch (SQLException e) {
		e.printStackTrace();
	}finally{
		relaseResourse();
	}
	
}
//删除数据操作方法
public static void delete(){
   try {
	stmt = conn.createStatement();
	String sql = "delete  from user where name='hah';";
	//执行
	int result = stmt.executeUpdate(sql);
	if(result>0){
		System.out.println("删除成功");
	}else{
		System.out.println("删除数据失败");
		
	}
	
} catch (SQLException e) {
	e.printStackTrace();
}finally{
	relaseResourse();
}
   
}

//修改方法
public static void update(){
	try {
		stmt = conn.createStatement();
		String sql = "update user set name = 'xiaoxiao' where id='6'";
		int result = stmt.executeUpdate(sql);
		if(result>0){
			System.out.println("修改成功");
		}else{
			System.out.println("修改数据失败");
			
		}
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}finally{
		relaseResourse();
	}
	
}


public static void main(String[] args) {
      JdbcDemo2.add();
}

}