jsp数据库应用开发

---

连接数据库+获取结果

---

import="java.sql.*,java.util.*"
final String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
	final String URL ="jdbc:sqlserver://localhost:1433;DatabaseName =bookshop";
	final String USER="sa";
	final String PASSWORD="zhou";
	Connection con=null;
	PreparedStatement ps=null;//准备好的sql语句
	ResultSet rs=null;//返回的结果集
	try{
		Class.forName(DRIVER);//加载驱动
		System.out.println("数据库驱动["+DRIVER+"]加载成功");
	}catch(ClassNotFoundException e){
		e.printStackTrace();
		System.out.println("数据库驱动["+DRIVER+"]加载失败");
	}
	
	try{
		con=DriverManager.getConnection(URL,USER,PASSWORD);//获取连接
	}catch(SQLException e){
		throw new RuntimeException("连接数据库失败",e);
	}
	String sql="select * from register "; //sql语句
	ps=con.prepareStatement(sql);//准备执行sql语句
	rs=ps.executeQuery();//执行sql语句获得一条条的数据放在resultset中
	while(rs.next()){
		rs.getInt("xxx");//获取int
		rs.getString("xxx");//获取sting
	}
	//关闭连接
	
	if(rs !=null){
		rs.close();
	}
	if(ps !=null){
		ps.close();
	}
	if( con !=null){    
		con.close();
	}

---

---