java连接数据库

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


public class DatabaseConnection {

	public static void main(String[] args) {
		statement();
		preparedStatement();
	}
	//创建Statement连接数据库
	public static void statement(){
		try {
			Class.forName("driverclass");
			Connection conn = DriverManager.getConnection("url", "user", "password");
			Statement stmt = conn.createStatement();
			ResultSet rs =  stmt.executeQuery("sql");
			while(rs.next()){
				System.out.println(rs.getString(0));
			}
			stmt.close();
			conn.close();
		} catch (SQLException e) {
			e.printStackTrace();
		} catch (ClassNotFoundException e1) {
			e1.printStackTrace();
		}
	}
	//创建PreparedStatement连接数据库
	public static void preparedStatement(){
		try {
			Class.forName("driverclass");
			Connection conn = DriverManager.getConnection("url", "user", "password");
			PreparedStatement pstmt = conn.prepareStatement("select * from test where id=?");
			//参数设值 索引从1开始的 ！！！
			pstmt.setString(1, "id");
			ResultSet rs =  pstmt.executeQuery();
			while(rs.next()){
				System.out.println(rs.getString(0));
			}
			pstmt.close();
			conn.close();
		} catch (SQLException e) {
			e.printStackTrace();
		} catch (ClassNotFoundException e1) {
			e1.printStackTrace();
		}
	}
}