如何用sql2005练数据库,能给个实例和详细配置吗,急用,在线等 如题 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 什么叫“练”数据库?楼主指的哪方面?别告诉我是想知道怎么用java连mssql2005。 http://www.diybl.com/course/3_program/java/javajs/2008217/100061.html import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class DBCon { private static String driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"; private static String url="jdbc:sqlserver://localhost:1433;databasename=stuDB"; private static String user="sa"; private static String pwd="sa"; public static Connection getConnection(){ try { Class.forName(driver); Connection con=DriverManager.getConnection(url, user, pwd); System.out.println("con success"); return con; } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return null; } public static void closeConnection(Connection con){ if(con!=null){ try { con.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } public static void closeStatement(Statement stm){ if(stm!=null){ try { stm.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } public static void closeResultSet(ResultSet rs){ if(rs!=null){ try { rs.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } public static void main(String[] args) { getConnection(); }}private static String url="jdbc:sqlserver://localhost:1433;databasename=stuDB"; private static String user="sa"; private static String pwd="sa"; 换你自己的用户名密码之类的 导入数据库jar包 sqlserverTCP/IP协议打开 服务打开 package ch01;import java.util.*;import java.sql.*;public class BaseDao { private final static String driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"; private static final String URL="jdbc:sqlserver://localhost:1433;DatabaseName=restrant";//DatabaseName后面跟的是数据库名称,相应的改一下 private final static String login="yuan"; private final static String passWord="1020"; public Connection getConnection(){ Connection con=null; try{ Class.forName(driver); con=DriverManager.getConnection(URL,login,passWord); }catch(Exception e){ e.printStackTrace(); } return con; } public void closePreparedStatement(PreparedStatement pStatement){ try{ if(pStatement!=null){ pStatement.close(); pStatement=null; } }catch(Exception e){ e.printStackTrace(); } } public void closeResultSet(ResultSet rs){ try{ if(rs!=null){ rs.close(); rs=null; } }catch(Exception e){ e.printStackTrace(); } } public void closeConnection(Connection conn){ try{ if(conn!=null&&(!conn.isClosed())){ conn.close(); } }catch(Exception e){ e.printStackTrace(); } }}在运行时不要忘记在程序中添加JDBC驱动 新人求救 关于hibernate 和jsonObject 请问下,jar里面类的源码怎么看 90后 java 的Jtable 如何编辑数据,然后写回到数据库 请哪位高手帮帮忙,自己实在无能为力了 eclipse内存配置问题 现在想和大家讨论一下,是否有一种途径。既能.net又不放弃jsp呢? 谁有JAVA操作OPENLDAP的实例呀,贴出来让小弟瞧下好吗? 各位高手看看,这是不是java编译器的bug java的XML解析程序是什么? dom4j生成xml,中文乱码,如何解决 spring基于注解的MVC中如何使用openSessionInViewInterceptor
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;public class DBCon {
private static String driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
private static String url="jdbc:sqlserver://localhost:1433;databasename=stuDB";
private static String user="sa";
private static String pwd="sa";
public static Connection getConnection(){
try {
Class.forName(driver);
Connection con=DriverManager.getConnection(url, user, pwd);
System.out.println("con success");
return con;
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}
public static void closeConnection(Connection con){
if(con!=null){
try {
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
public static void closeStatement(Statement stm){
if(stm!=null){
try {
stm.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
public static void closeResultSet(ResultSet rs){
if(rs!=null){
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
public static void main(String[] args) {
getConnection();
}
}private static String url="jdbc:sqlserver://localhost:1433;databasename=stuDB";
private static String user="sa";
private static String pwd="sa";
换你自己的用户名密码之类的
导入数据库jar包 sqlserverTCP/IP协议打开 服务打开
import java.util.*;
import java.sql.*;
public class BaseDao {
private final static String driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
private static final String URL="jdbc:sqlserver://localhost:1433;DatabaseName=restrant";//DatabaseName后面跟的是数据库名称,相应的改一下
private final static String login="yuan";
private final static String passWord="1020";
public Connection getConnection(){
Connection con=null;
try{
Class.forName(driver);
con=DriverManager.getConnection(URL,login,passWord);
}catch(Exception e){
e.printStackTrace();
}
return con;
}
public void closePreparedStatement(PreparedStatement pStatement){
try{
if(pStatement!=null){
pStatement.close();
pStatement=null;
}
}catch(Exception e){
e.printStackTrace();
}
}
public void closeResultSet(ResultSet rs){
try{
if(rs!=null){
rs.close();
rs=null;
}
}catch(Exception e){
e.printStackTrace();
}
}
public void closeConnection(Connection conn){
try{
if(conn!=null&&(!conn.isClosed())){
conn.close();
}
}catch(Exception e){
e.printStackTrace();
}
}
}
在运行时不要忘记在程序中添加JDBC驱动