package DBmanage; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.text.DecimalFormat; import java.util.Properties;
public class DatabaseConnection { private static Connection conn = null; private static String dbUrl = "jdbc:Access://学生成绩管理.accdb"; private static Statement stmt = null; private static ResultSet rs = null; public static Connection getConn() { Properties prop = new Properties(); prop.put("charSet", "UTF-8"); String driver = "com.hxtt.sql.access.AccessDriver"; Connection conn = null; try { Class.forName(driver); //classLoader,加载对应驱动 conn = DriverManager.getConnection(dbUrl, prop); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } return conn; } public static ResultSet executeQuery(String sql){ conn = getConn(); try { stmt = conn.createStatement(); rs = stmt.executeQuery(sql);
} catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } if(rs == null){ System.out.println("执行的时候错误ִ"); } return rs; } public static int executeUpdate(String sql){ int result = 1; conn = getConn(); try { stmt = conn.createStatement(); result = stmt.executeUpdate(sql); } catch (SQLException e) { e.printStackTrace(); result = 0; } return result; }
}
