package net.lisoft.db;
import java.sql.*;
import java.lang.*;
import java.util.ArrayList;
import java.util.List;
import java.util.Date;
import java.text.SimpleDateFormat;
public class DbServer {
// 根据sSQL命令返回数据集
public ResultSet Execute(String sSQL) throws InstantiationException,
IllegalAccessException, ClassNotFoundException, SQLException {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver")
.newInstance();
// String url =
// "jdbc:microsoft:sqlserver://LC_QZF\SQLEXPRESS:1433;DatabaseName=nmykt";
String url = "jdbc:microsoft:sqlserver://WS03-20130314NE:1433;DatabaseName=nmykt";
// pubs为你的数据库的
String user = "sa";
String password = "sa";
// 不知道为什么这句话这么的慢;
Connection conn = DriverManager.getConnection(url, user, password);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");// 设置日期格式
System.out.println("开始执行SQL命令:" + df.format(new Date()));
System.out.println("SQL命令:" + sSQL);
ResultSet rs = stmt.executeQuery(sSQL);
System.out.println("结束时间:" + df.format(new Date()));
return rs;
}
}
标签: