上机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();
}
}