有什么方法可以连接到MS SQL Server数据库呢? 1、用jdbc-odbc桥2、用微软或BEA提供的 Type4 驱动程序 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 还有就是怎么安装JDBC驱动程序呢?在哪里有的下载? 给你个地址,这里有sqlserver的jdbc。ftp://202.118.75.204/pub/Java/JDBC/MSDriver.zip还有ms自己也有jdbc驱动下载。在sina里搜一下就有了。 驱动这样调用。package UsefulClasses;import java.sql.*;public class Database{ //String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; //String sConnStr = "jdbc:odbc:Mechanism"; String sDBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver"; String sConnStr="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=Mechanism"; Connection conn = null; Statement stmt = null; ResultSet rs = null; public Database() { try { Class.forName(sDBDriver); } catch(java.lang.ClassNotFoundException e) { System.err.println("SQL Driver not found:" + e.getMessage()); } } public void executeInsert(String sql) { try { conn = DriverManager.getConnection(sConnStr,"",""); stmt = conn.createStatement(); stmt.executeUpdate(sql); stmt.close(); conn.close(); } catch(SQLException ex) { System.err.println("SQL insert error:"+ex.getMessage()); } } public ResultSet executeQuery(String sql) { try { conn = DriverManager.getConnection(sConnStr,"user","111111"); stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); rs = stmt.executeQuery(sql); } catch(SQLException ex) { System.err.println("SQL query error:"+ex.getMessage()); } return rs; } public ResultSet executePreparedQuery(String sql) { try { //conn = DriverManager.getConnection(sConnStr,"",""); //stmt = conn.createPreparedStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); //rs = stmt.executePreparedQuery(sql); stmt = conn.prepareStatement(sql,ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); } catch(SQLException ex) { System.err.println("SQL prepared query error:"+ex.getMessage()); } return rs; } public void executeUpdate(String sql) { try { conn = DriverManager.getConnection(sConnStr,"user","111111"); stmt = conn.createStatement(); stmt.executeUpdate(sql); stmt.close(); conn.close(); } catch(SQLException ex) { System.err.println("SQL update error: " + ex.getMessage()); } } public void executeDelete(String sql) { try { conn = DriverManager.getConnection(sConnStr,"",""); stmt = conn.createStatement(); stmt.executeUpdate(sql); stmt.close(); conn.close(); } catch(SQLException ex) { System.err.println("SQL delete error:"+ex.getMessage()); } } public void closeStmt() { try { stmt.close(); } catch(SQLException e) { e.printStackTrace(); } } public void closeConn() { try { conn.close(); } catch(SQLException e) { e.printStackTrace(); } }} 你这个是用MS的驱动程序,但听说用MS的驱动程序不太好,还有没有其他的方法呢? 使用JAVA中的SQL类,其中有读取、改变和删除数据库的方法! sqlserver2000 bcp导出数据问题。 java写xml jsp分页功能 一个用户输入问题 有没有只针对24小时的Date类,就是说无视前面的年月日 一个程序和一个问题 新手 为什么提示 Exception in thread "main" java.lang.NoClassDefFoundError: 请教怎样将JTable加入到JSplitPane里?急!!! repaint()方法是哪个类的? 在问一个无知的问题,高手看看,分数不多了,见谅 向文件中写入实数 application中能跑的程序applet中不能跑,多谢指点
ftp://202.118.75.204/pub/Java/JDBC/MSDriver.zip
还有ms自己也有jdbc驱动下载。在sina里搜一下就有了。
package UsefulClasses;
import java.sql.*;
public class Database
{
//String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
//String sConnStr = "jdbc:odbc:Mechanism";
String sDBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String sConnStr="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=Mechanism";
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
public Database()
{
try
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("SQL Driver not found:" + e.getMessage());
}
}
public void executeInsert(String sql)
{
try
{
conn = DriverManager.getConnection(sConnStr,"","");
stmt = conn.createStatement();
stmt.executeUpdate(sql);
stmt.close();
conn.close();
}
catch(SQLException ex)
{
System.err.println("SQL insert error:"+ex.getMessage());
}
}
public ResultSet executeQuery(String sql)
{
try
{
conn = DriverManager.getConnection(sConnStr,"user","111111");
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println("SQL query error:"+ex.getMessage());
}
return rs;
}
public ResultSet executePreparedQuery(String sql)
{
try
{
//conn = DriverManager.getConnection(sConnStr,"","");
//stmt = conn.createPreparedStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
//rs = stmt.executePreparedQuery(sql);
stmt = conn.prepareStatement(sql,ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
}
catch(SQLException ex)
{
System.err.println("SQL prepared query error:"+ex.getMessage());
}
return rs;
}
public void executeUpdate(String sql)
{
try
{
conn = DriverManager.getConnection(sConnStr,"user","111111");
stmt = conn.createStatement();
stmt.executeUpdate(sql);
stmt.close();
conn.close();
}
catch(SQLException ex)
{
System.err.println("SQL update error: " + ex.getMessage());
}
}
public void executeDelete(String sql)
{
try
{
conn = DriverManager.getConnection(sConnStr,"","");
stmt = conn.createStatement();
stmt.executeUpdate(sql);
stmt.close();
conn.close();
}
catch(SQLException ex)
{
System.err.println("SQL delete error:"+ex.getMessage());
}
}
public void closeStmt()
{
try
{
stmt.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
public void closeConn()
{
try
{
conn.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}}