JDBC代码示例

public class JDBCTest {
	private static final String DBDRIVER = "com.mysql.jdbc.Driver";
	private static final String DBURL = "jdbc:mysql://192.168.101.177:3306/wscfs";
	private static final String USER = "wscfs";
	private static final String PASSWORD = "wscfs";
	private static Connection conn = null;
	
	public static Connection getConnection() throws Exception{
		if(conn != null){
			return conn;
		}
		//	1.加载数据库的驱动程序（向容器加载，不需要实例化，因为容器自己会负责）
		Class.forName(DBDRIVER);
		//	2.进行数据库连接（通过DriverManager类完成，Connection表示连接）
		conn = DriverManager.getConnection(DBURL, USER, PASSWORD);
		if(conn == null){
			throw new Exception("数据库连接失败。。。");
		}
		System.out.println("数据库启动。。。");
		return conn;
	}
	
	//PreparedStatement
	public  static PreparedStatement getPreparedStatement(String sql) throws Exception{
		//3.进行数据的CRUD