test.java

来自「这是java的源代码,感觉上是挺不错的哦,要下载赶快来哦,有附加数据库的哦」· Java 代码 · 共 64 行

package ptu.main;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import ptu.db.DBConnection;



public class Test {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		Connection con=null;
		PreparedStatement statement=null;
		ResultSet rs=null;
		
		try {
			con=DBConnection.getConnection();
			
			//插入字段
			//statement=con.prepareStatement("insert into student values('1','2')");
			//statement.execute();
		
			//修改字段
			//statement=con.prepareStatement("update student set studentId = '35' where ID='35'");
			//statement.execute();
			
			//删除字段
			//statement=con.prepareStatement("delete from student where ID='34'");
			//statement.execute();

			//修改字段
			//statement=con.prepareStatement("update student set studentId = '35' where ID='35'");
			//statement.execute();
			
			//插入字段
			//statement=con.prepareStatement("insert into student values('1','2')");
			//statement.execute();

			//查找表中的信息
			statement=con.prepareStatement("SELECT * from  student");
			rs=statement.executeQuery();
			
			while(rs.next()){
				System.out.print(rs.getInt(1)+"\t");
				System.out.print(rs.getInt(2)+ "\t");
				System.out.println(rs.getString(3));
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			DBConnection.closeResultSet(rs);
			DBConnection.closeStatement(statement);
			DBConnection.closeConnection(con);
		}
	}

}