jdbcexample1.java

来自「这是一个关于jsp的学习文档.为学习jsp的朋友提供方便」· Java 代码 · 共 33 行

import java.sql.*;

public class JDBCExample1
  {	
     public static void main(String args[])
      {
        String serverName = "localhost";
	try{
	    Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();    
            String  url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test";    
           //test为你的数据库的    
           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  auser";    
           ResultSet  rs=stmt.executeQuery(sql);    
           while(rs.next())  
             {
	       System.out.print("DeptNo: "+rs.getInt(1));
	       System.out.print("\tDeptName: "+rs.getString(1));
	       System.out.println("\tLOC: "+rs.getString(2));
	     }
           rs.close();
           stmt.close();
           conn.close();
	}
      catch(Exception e)
        {e.printStackTrace();
	}
     }
 }