Java开发网 Java开发网
注册 | 登录 | 帮助 | 搜索 | 排行榜 | 发帖统计  

您没有登录

» Java开发网 » Database/JDBC/SQL/JDO/Hibernate » MS SQL  

按打印兼容模式打印这个话题 打印话题    把这个话题寄给朋友 寄给朋友    该主题的所有更新都将Email到你的邮箱 订阅主题
flat modethreaded modego to previous topicgo to next topicgo to back
作者 不能连上数据库!!
james19790619





发贴: 15
积分: 0
于 2005-06-02 22:56 user profilesend a private message to usersearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
import java.sql.*;

public class testRoll
{
  public static void main(String [] args)
  {
    String url="jdbc:microsoft:sqlserver://localhost:1433;"+"DatabaseName=xscj";
    Connection con;
    Statement st;
    try
    {
      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
    }
    catch(ClassNotFoundException e)
    {
      System.out.println("Driver can't be loaded");
      System.out.println(e.getMessage());
    }
    String username="sa";
    String password="001301";
    try
    {
      con=DriverManager.getConnection(url,username,password);
      st=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
      ResultSet rs=st.executeQuery("SELECT * FROM XS");
      rs.absolute(4);
      int rowNum=rs.getRow();
      System.out.println("rowNum:\t"+rowNum);
      rs.relative(-3);
      rowNum=rs.getRow();
      System.out.println("rowNum:\t"+rowNum);
      rs.absolute(1);
      System.out.println("after last?"+rs.isAfterLast());
      if(!rs.isAfterLast())
      {
        int nID=rs.getInt("学号");
        String strName=rs.getString(" 姓名");
        
        System.out.println("id:"+nID+"\tname:"+strName);
      }
      rs.close();
      st.close();
      con.close();
    }
    catch(SQLException se)
    {
      System.out.println("SQLException:"+se.getMessage());
    }
  }
}




话题树型展开
人气 标题 作者 字数 发贴时间
8341 不能连上数据库!! james19790619 1275 2005-06-02 22:56
6058 Re:不能连上数据库!! why 25 2005-06-02 23:43
6615 Re:不能连上数据库!! james19790619 174 2005-06-03 23:01
6044 Re:不能连上数据库!! why 129 2005-06-03 23:13
6453 Re:不能连上数据库!! why 252 2005-06-05 06:14

flat modethreaded modego to previous topicgo to next topicgo to back
  已读帖子
  新的帖子
  被删除的帖子
Jump to the top of page

   Powered by Jute Powerful Forum® Version Jute 1.5.6 Ent
Copyright © 2002-2021 Cjsdn Team. All Righits Reserved. 闽ICP备05005120号-1
客服电话 18559299278    客服信箱 714923@qq.com    客服QQ 714923