Question

Eclipse中用jdbc驱动程序直接操作sql server数据库，如何进行连接？我已经安装了三个驱动jar包

public static void main(String[] args)
{
//定义需要的对象
Connection ct=null;
PreparedStatement ps=null;
ResultSet rs=null;
//初始化我们的对象
try {
//加载驱动
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
//得到连接
ct=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databaseName=LiangShanHero","sa","muziwen1987");
//创建
ps=ct.prepareStatement("select * from hero");
//运行
rs=ps.executeQuery();
运行结果是：[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]无法打开登录 'LiangShanHero' 中请求的数据库。登录失败。

Answer 1

JDBC连接数据库并建表
package jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class JDBCConnection {

/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
try {
//注册，加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//数据库连接
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","scott","scott");
//执行语句
Statement state=con.createStatement();//创建Statement对象
String sql="create table TEACHER(tno varchar2(10),tname char(10))";//创建TEACHER表
state.executeUpdate(sql);//执行sql语句
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}