java数据库操作

/sql server 要升级到SP3

 

package JOC;

import java.sql.*;

public class db {
 /**
  * @param args
  */
 public static void main(String[] args) {
  // TODO Auto-generated method stub  
  String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
  String dbURL = "jdbc:microsoft:sqlserver://localhost:1434; DatabaseName=test";
  String userName = "satest";
  String userPwd = "123";   
  Connection dbConn;   
  try {
    Class.forName(driverName);
    dbConn = DriverManager.getConnection(dbURL, userName, userPwd);    
    String sql = "select * from job ";
    Statement sm = dbConn.createStatement();
    ResultSet rs = sm.executeQuery(sql);   
    //DataSource ds = sm.executeQuery(sql); 
    // sm.executeUpdate(sql); // 执行数据更新语句(delete、update、insert、drop等)statement.close();   
    while(rs.next())
    {    
     System.out.print(rs.getString("jobid"));
     System.out.print(rs.getString("jobname"));
     System.out.print(rs.getString("jobcontent"));
     System.out.print(rs.getString("createdate"));
     System.out.println("Connection Successful!");
    }  
   }
    catch (Exception e) {
    e.printStackTrace();
   }   

 }

} 

 

输出结果

1         job1      test1                                             2007-12-13 00:00:00.0Connection Successful!
2         job2      test2                                             2007-12-13 00:00:00.0Connection Successful!
3         job3      test3                                             2007-12-14 00:00:00.0Connection Successful!
4         job4      test4                                             2007-12-14 00:00:00.0Connection Successful!
5         job5      test4                                             2007-12-15 00:00:00.0Connection Successful!
6         job6      test4                                             2007-12-15 00:00:00.0Connection Successful!
7         job7      test4                                             2007-12-16 00:00:00.0Connection Successful!
8         job8      test4                                             2007-12-16 00:00:00.0Connection Successful!