JDBC

所需jar包
oracle:ojdbc6.jar(在oracle数据库文件夹下的jdbc/lib下能找到)
mysql:mysql-connector-java-5.1.39-bin.jar
直接上代码

public void login(String username, String password) throws ClassNotFoundException, SQLException {
		// 1.注册驱动
		Class.forName("com.mysql.jdbc.Driver");
		// 2.获取连接
		Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/dbname", "username", "password");
		// 3.编写sql语句
		String sql = "select * from tbl_user where uname=? and upassword=?";
		// 4.创建预处理对象
		PreparedStatement pstmt = conn.prepareStatement(sql);
		// 5.设置参数(给占位符)
		pstmt.setString(1, username);
		pstmt.setString(2, password);
		// 6.执行查询操作
		ResultSet rs = pstmt.executeQuery();
		// 7.对结果集进行处理
		if (rs.next()) {
			System.out.println("恭喜您，" + username + ",登录成功!");
			System.out.println(sql);
		} else {
			System.out.println("账号或密码错误!");
		}
		if (rs != null)
			rs.close();
		if (pstmt != null)
			pstmt.close();
		if (conn != null)
			conn.close();
	}

增删改就使用int row = pstmt.executeUpdate();这个方法，返回影响行数

DBUtils的封装

package jdbc.utils;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ResourceBundle;

public class JDBCUtils {

	private static String driver = "";
	private static String url = "";
	private static String username = "";
	private static String password = "";
	
	
	
	static{
		ResourceBundle resource = ResourceBundle.getBundle("db");
		driver = resource.getString("driver");
		url = resource.getString("url");
		username = resource.getString("username");
		password = resource.getString("password");
	}
	
	
	public static Connection getConnection(){
		Connection conn = null;
		try {
			Class.forName(driver);
			conn = DriverManager.getConnection(url,username,password);
		} catch (SQLException e) {
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
		return conn;
	}
	
	
	public static void releaseResources(Connection conn,PreparedStatement pstmt,ResultSet rs){
		if(rs!=null){
			try {
				rs.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		if(pstmt!=null){
			try {
				pstmt.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		if(conn!=null){
			try {
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
}

配置文件db.properties

#mysql
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/dbname?useUnicode=true&characterEncoding=utf8
username=root
password=root
############################################################
#oracle
#driver=oracle.jdbc.OracleDriver
#url=jdbc:oracle:thin:@127.0.0.1:1521:tgood
#username=infodba
#password=infodba