JAVA OOP第八章JDBC 上机+课后

上机1  建立连接数据库
package cn.happy4.com;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class test {

	public static void main(String[] args) throws Exception{
		// TODO Auto-generated method stub

		Connection con=null;
		
		try{
			 String driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
			  String url="jdbc:sqlserver://localhost:1433;DatabaseName=MySchool";
			  String username="sa";
			  String pwd="1";
			  Class.forName(driver);
		 con=DriverManager.getConnection(url, username, pwd);
			System.out.println("建立连接成功！");
		}catch(SQLException e){
			System.out.println("建立连接失败");
		}
		finally{
			try{
				if(null!=con){
					con.close();
					System.out.println("关闭连接成功");
				}
			}catch(SQLException e){
				System.out.println("关闭连接失败");
			}
		}
	}

}

上机2  查询信息
package cn.happy5.com;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class TestJDBC2 {
	public static void main(String[] args) throws Exception{
		// TODO Auto-generated method stub		
		ResultSet rs=null;
		 String driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
		  String url="jdbc:sqlserver://localhost:1433;DatabaseName=epet";
		  String username="sa";
		  String pwd="1";
		  Class.forName(driver);
		  Connection con=DriverManager.getConnection(url, username, pwd);
		  Statement state=con.createStatement();
		
		  rs=state.executeQuery("select * from Person");
		  System.out.println("主人信息列表：");
		  System.out.println("编号 \t姓名\t元宝数");
		  while(rs.next()){
			  System.out.print(rs.getInt("id")+"\t");
			  System.out.print(rs.getString("name")+"\t");
			  System.out.println(rs.getInt("money")+"\t");
		  }

		  state.close();
		  con.close();
		  
			

}
}