求用JDBC与SQL-SEVER2000连接的例子 看看这个:http://tech.enet.com.cn/document/20010910/2001091014264501.shtml 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 import java.sql.*;import com.microsoft.jdbc.sqlserver.*;public class YY{ public static void main(String args[]){ try{ Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://.:1433","sa","123"); Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); String sql="SELECT * FROM test"; ResultSet rs=stmt.executeQuery(sql); rs.next();System.out.println(rs.getString(1));or//--------------------------------<?xml version="1.0" ?><config> <drivername>com.microsoft.jdbc.sqlserver.SQLServerDriver</drivername> <connection>jdbc:microsoft:sqlserver://.:1433</connection> <user>sa</user> <password>123</password></config>public class Initweb{ private String xml; private String drivername; private String connection; private String user; private String password; public void setXml(String tablename){ try{ Class.forName(drivername); Connection conn = DriverManager.getConnection(connection,user,password); String sql ="SELECT id,name FROM bcstnet.dbo."+tablename+" FOR XML RAW"; Statement stmt=conn.createStatement(); ResultSet rs=stmt.executeQuery(sql); xml="<?xml version=\"1.0\" encoding=\"gb2312\"?>"; xml+="<root>"; while(rs.next()) xml+=rs.getString(1); 我用的是WEBSPHERE+SQLSEVER2000该如何设置呢,有没有这方面的资料 我想打开一个jsp的页面就跳转到servlet中去,并向servlet传值。用什么跳转 求助..关于项目部署问题 jfreereport servlet包名的命名原则 如何获取String文本的部分内容进行输出 javax.transaction.UserTransaction和net.sf.hibernate.Transaction的区别? antlr入门教程1 框架的问题?求大神解答 我的j2ee1.4起不来!大家帮我看一下呀。 购买:weblogic_sp.jar文件... 请问怎样bind到jboss的Naming server 运行EJB+JSP的组合(见内)
import com.microsoft.jdbc.sqlserver.*;public class YY{
public static void main(String args[]){
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://.:1433","sa","123");
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql="SELECT * FROM test";
ResultSet rs=stmt.executeQuery(sql);
rs.next();System.out.println(rs.getString(1));
or
//--------------------------------<?xml version="1.0" ?>
<config>
<drivername>com.microsoft.jdbc.sqlserver.SQLServerDriver</drivername>
<connection>jdbc:microsoft:sqlserver://.:1433</connection>
<user>sa</user>
<password>123</password>
</config>
public class Initweb{
private String xml; private String drivername;
private String connection;
private String user;
private String password; public void setXml(String tablename){
try{
Class.forName(drivername);
Connection conn = DriverManager.getConnection(connection,user,password); String sql ="SELECT id,name FROM bcstnet.dbo."+tablename+" FOR XML RAW"; Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery(sql); xml="<?xml version=\"1.0\" encoding=\"gb2312\"?>";
xml+="<root>";
while(rs.next()) xml+=rs.getString(1);