第1个回答 推荐于2016-04-07
用myeclipse把少年
下面的代码还要下载jdbc 驱动包 sqlserver版本
import java.sql.*;
public class DB {
String databasename;//数据库名称
private static final String DRIVER_CLASS ="com.microsoft.sqlserver.jdbc.SQLServerDriver";
private static final String DATABASE_URL = "jdbc:sqlserver://localhost:1433;“ +databasename+"=data";
private static final String DATABASE_USER ="sa";
private static final String DATABASE_PASSWORD="sa";
//得到数据库的链接
public static Connection getConnection(){
Connection con = null;
try{
Class.forName(DRIVER_CLASS);
con = DriverManager.getConnection(DATABASE_URL, DATABASE_USER, DATABASE_PASSWORD);
}catch(Exception ex){
ex.printStackTrace();
}
return con;
}
//得到Statement 对象用于执行sql语句
public static Statement getStmt(Connection conn){
try{
Statement stmt = conn.createStatement();
return stmt;
}catch(SQLException ex){
ex.printStackTrace();
}
return null;
}
//执行sql语句返回结果集
public static ResultSet executeQuery(String sql,Statement stmt ){
ResultSet rs = null;
try{
rs = stmt.executeQuery(sql);
}catch(SQLException ex){
ex.printStackTrace();
}
return rs;
}本回答被提问者采纳