如何用JDBC访问SQLServerl里面的数据裤（急，在线等）

xyjzd 2004-05-09 01:55:02

请写一个简单的例子，包括文档说明

...全文

70 8 打赏收藏转发到动态举报

写回复

用AI写文章

8 条回复

切换为时间正序

请发表友善的回复…

发表回复

jinsfree 2004-05-10

打赏
举报

嗯，应该也差不多了吧

superryu 2004-05-10

打赏
举报

该说的楼上都说了

追求自由 2004-05-09

打赏
举报

不好意思，刚才忘记贴程序了
<%@ page language="java" contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="javax.naming.*"%>
<%/*Class.forName("com.internetcds.jdbc.tds.Driver").newInstance();
String url="jdbc:freetds://server:1488/newXXFB";
Connection con= DriverManager.getConnection(url,"qcc","qcc");
Statement smt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs;

String sql="select * from infomation";
System.out.println(sql);
rs=smt.executeQuery(sql);
while (rs.next()){

System.out.println(rs.getString(1));

}
*/
%>
<%
//这是直接连接
/*
Driver myDriver =(Driver)Class.forName("weblogic.jdbc.mssqlserver4.Driver").newInstance();

String driverURL = "jdbc:weblogic:mssqlserver4";
Properties myProperties = new Properties();
myProperties.put("server", "server:1488");
myProperties.put("db", "newXXFB");
myProperties.put("user", "qcc");
myProperties.put("password", "qcc");
Connection con =myDriver.connect(driverURL, myProperties);
Statement smt=con.createStatement();
ResultSet rs;
String sql="select * from infomation";
System.out.println(sql);
rs=smt.executeQuery(sql);
while (rs.next()){
System.out.println(rs.getString(1));
}
*/
%>
<%//用连接池连接
/*
String driverName = "weblogic.jdbc.pool.Driver";
Driver myDriver =(Driver)Class.forName(driverName).newInstance();
String driverURL = "jdbc:weblogic:pool:sqlPool";
Connection con =myDriver.connect(driverURL, null);
Statement smt=con.createStatement();
ResultSet rs;
String sql="select * from infomation";
System.out.println(sql);
rs=smt.executeQuery(sql);
while (rs.next()){
System.out.println(rs.getString(1));
}*/

%>
<%//用datasourcce连接数据库
javax.sql.DataSource myDS = null;
Connection con=null;
try {
Context myContext = new InitialContext();
myDS = (javax.sql.DataSource) myContext.lookup("myDataSource");
}
catch (NamingException e) {
}
try {
con = myDS.getConnection();
}
catch (SQLException e) {
}
Statement smt=con.createStatement();
ResultSet rs;
String sql="select * from infomation";
System.out.println(sql);
rs=smt.executeQuery(sql);
while (rs.next()){
System.out.println(rs.getString(1));
}

try{
con.close();
}
catch (SQLException e)
{ System.out.println(e.getMessage());
}
%>

yaomengqiushui 2004-05-09

打赏
举报

Lomone 2004-05-09

打赏
举报

import java.sql.*;
public class conn{
private String userName="";
private String password="";
public conn(String userName,String password){
this.userName = userName;
this.password = password;
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();

Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=yourdb
Connection conn= DriverManager.getConnection(url,user,password);

String sql="select * from test";
do{
ResultSet rs=stmt.executeQuery(sql);
}while(rs.next())
}
}
以上就是一个简单的连接类了!!

Arias 2004-05-09

打赏
举报

二、jsp连接Sql Server7.0/2000数据库
testsqlserver.jsp如下：
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
//pubs为你的数据库的
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from test";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一个字段内容为：<%=rs.getString(1)%>
您的第二个字段内容为：<%=rs.getString(2)%>
<%}%>
<%out.print("数据库操作成功，恭喜你");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>

这是一个简单的连接sqlserver数据库的例子，你要写成java文件只需要把里面的连接以及
其他执行的executeQuery以及executeUpdate等的操作封装在你设计的类中就可以那！

sasa_sasa 2004-05-09