erp系统/src/com/util/DBConn.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.util;

import java.io.UnsupportedEncodingException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Properties;

public class DBConn {

 /*   private static final String DRIVER = "com.mysql.jdbc.Driver";
 	private static final String URL = "jdbc:mysql://localhost:3306/xuanke?useUnicode=true&characterEncoding=utf-8&useOldAliasMetadataBehavior=true";
 	private static final String USERNAME = "root";
 	private static final String PASSWORD = "mysql";
	*/
 
	private static Connection conn;
	private Statement stmt;
	private ResultSet rs;
	public DBConn() {
	}

	public static synchronized Connection getConn() {
		try {
			Properties properties = new Properties();
			properties.load(DBConn.class.getClassLoader().getResourceAsStream("jdbc.properties"));
			String driver = properties.getProperty("jdbc.driverClassName");
			String url = properties.getProperty("jdbc.url");
			String username = properties.getProperty("jdbc.username");
			String password = properties.getProperty("jdbc.password");
			Class.forName(driver);
			conn = DriverManager.getConnection(url, username, password);
			 //conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databasename=zuoyetijiao","sa","think");
	           
		} catch (Exception e) {
		}
		return conn;
	}

	public void init(Connection conn) {
		try {
			stmt = conn.createStatement();
		} catch (Exception e) {
		}
	}

	public void close() {
		try {
			if (rs != null)
				rs.close();
		} catch (Exception e) {
		}
		try {
			if (stmt != null)
				stmt.close();
		} catch (Exception e) {