去微软去下载一个sql server2000 jdbc驱动,然后放置在web-inf/lib中,然后这样使用:
private static final String sDBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
private static final String sConnStr="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=Mechanism";
private static Connection conn = null;
private static Statement stmt = null;
try
{
Class.forName(sDBDriver);
}
conn = DriverManager.getConnection(sConnStr,"user","111111");
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
stmt.executeUpdate(sql);
private static final String sDBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
private static final String sConnStr="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=Mechanism";
private static Connection conn = null;
private static Statement stmt = null;
try
{
Class.forName(sDBDriver);
}
conn = DriverManager.getConnection(sConnStr,"user","111111");
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
stmt.executeUpdate(sql);
<%@ page import="java.sql.*" %>
<%
String driver = "com.merant.datadirect.jdbc.sqlserver.SQLServerDriver";
String newurl = "jdbc:sqlserver://192.168.1.6:1433";
String newuser = "jive";
String newpassword = "jive";
Class.forName(driver);
Connection con = DriverManager.getConnection(newurl, newuser, newpassword);
out.print(con);
//con.close();
%>
到http://industry.java.sun.com/products/jdbc/drivers
去找吧
String connectUrl = "jdbc:microsoft:sqlserver://localhost:1433";
String userName = "sa";
String userPass = "";
Class.forName(driverClass);
Connection conn = DriverManager.getConnection(connectUrl,userName,userPass);
conn.setCatalog("dbName");
Statement st = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs = null;
String sqlStr = "select ..... ";
rs = st.executeQuery(sqlStr);
while ( rs.next() ) {
//do something
}
rs.close();
st.close();