JDBC操作小例子

   使用eclipse开发工具，连接mysql数据库，使用jdbc完成增加和查询操作。

 

package myPackage;

import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;


public class JDBCInsert {
	
	//数据库路径
	static String DATABASE_URL = "jdbc:mysql://127.0.0.1/work";
	
	//数据库的账号密码
	static String USERNAME = "root";
	static String PASSWORD = "1234";
	
    public static void main(String args[]){
    	Connection conn = null;
    	PreparedStatement stmt = null;
    	try{
    		//注册数据库驱动
    		Driver driver = new com.mysql.jdbc.Driver();
    		DriverManager.registerDriver(driver);
    		
    		//创建一个数据库连接
    		conn = DriverManager.getConnection(DATABASE_URL, USERNAME, PASSWORD);
    		
    		//执行一个数据库新增操作
    		String sqlInsert = "insert acct_authority value(?, ?)";
    		stmt = conn.prepareStatement(sqlInsert);
    		stmt.setString(1, "002");
    		stmt.setString(2, "维护用户");
    		
    		int isSuccess = stmt.executeUpdate();
    		if(isSuccess == 1){                    //新增成功
    			stmt.close();
    			//执行一个查询操作
    			String sqlQuery = "select * from acct_authority where id = ?";
    			stmt = conn.prepareStatement(sqlQuery);
    			stmt.setString(1, "002");
    			ResultSet rs = stmt.executeQuery();
    			while(rs.next()){
    				System.out.print("id = "+ rs.getString("id")+",");
    				System.out.println("name = "+ rs.getString("name"));
    			}
    			rs.close();
    		}
    		//回收资源
    		stmt.close();
    		conn.close();
    	}catch(SQLException es){
    		es.printStackTrace();
    	}finally{
    		try{
    			if(stmt != null){
    				stmt.close();
    			}
    		}catch(SQLException est){
				est.printStackTrace();
			}
    		
    		try{
    			if(conn != null){
    				conn.close();
    			}
    		}catch(SQLException est){
				est.printStackTrace();
			}
    	}
    	System.out.println("GOOD BYE");
    }
    }