title: 数据库预处理方法
tag: [数据库,java]
categories: 数据库
package useJDBC;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class DAO {
//有关数据库使用的类
protected static String dbClassName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
protected static String dbUrl = "jdbc:sqlserver://localhost:1433;"//java连接sqlServer数据库的方法
+ "DatabaseName=test;";
protected static String dbUser = "sa";
protected static String dbPwd = "123456";
private static Connection conn = null;
private DAO() {// 获得数据库连接
try {
if (conn == null) {
Class.forName(dbClassName).newInstance();
conn = Driv