lab4.java

这个适用于初学者,JDBC连接MYSQL,这些是JDBC一些测试程序

package jdbc;
import java.sql.*;

public class Lab4
{
	public static void main(String[] args){
	  Connection con = null;
	  Statement stmt = null;
	  ResultSet rs = null;
	  try{
	    //1.注册驱动
		String driverName = 
			"oracle.jdbc.driver.OracleDriver";
		Class.forName(driverName);
		//2.连接数据库
		String url = 
		  "jdbc:oracle:thin:@192.168.0.20:1521:tarena";
		String username = "openlab";
		String pwd = "open123";
		con = DriverManager.getConnection(
			url,username,pwd);
		//3.创建Statement 对象
		stmt = con.createStatement();
		//4.查询数据库
		String sql = "select id,name from t_test";
		rs = stmt.executeQuery(sql);
		System.out.println("rs->"+rs);

		StringBuffer sb = new StringBuffer();
		while(rs.next()){
		  sb.append("id="+rs.getInt(1)+"  ");
		 sb.append("name="+rs.getString(2)+"\n");
		}
		System.out.println(sb.toString());
	  }catch(Exception e){
	    e.printStackTrace();
	  }finally{
		  try{
			  if(rs!=null) rs.close();
			}catch(Exception e1){
			  e1.printStackTrace();
			}
			try{
			  if(stmt!=null) stmt.close();
			}catch(Exception e1){
			  e1.printStackTrace();
			}
			try{
			  if(con!=null) con.close();
			}catch(Exception e1){
			  e1.printStackTrace();
			}
	  }
	}
}