jdbctest1.java

用jsp,servlet实现人力资源管理系统

package cn.com.login;

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


public class JDBCTest1 {
	Statement stmt = null;
	Connection conn = null;
	String sql=null;
	ResultSet set=null;
		public ResultSet getInfo(String id,String pass){

		
		
		try {
			//注册
			 Class.forName("oracle.jdbc.driver.OracleDriver");
			//取得连接
			 conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:WOLF","system","system");
			//创建Statement
			 stmt = conn.createStatement();
			 sql="SELECT EMP_NAME,EMP_ID,EMP_IDENFY,PART_ID,EMP_PASSWORD from emp_info where EMP_ID = '" + id +"' and EMP_PASSWORD = '"+pass+"'";
			 set=stmt.executeQuery(sql);

				
				
			} catch (SQLException e) {
				e.printStackTrace();
			}catch (ClassNotFoundException e) {
				e.printStackTrace();
			}
			return set;
			
			
		}
		public void connClose(){

			try {
				set.close();
				stmt.close();
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}

		}
//		public static void main(String args[]){
//			JDBCTest1 jd = new JDBCTest1();
//			ResultSet r = null;
//			String name = null;
//			String id = null;
//			String pass = null;
//			r = jd.getInfo("1","031225");
//			try {
//				while(r.next()){
//					
//					name = r.getString("EMP_NAME");
//					id = r.getString("EMP_ID");
//					pass = r.getString("EMP_IDENFY");
//					System.out.println("name is :" + name +"  id is :"+id + "    password is :"+pass);
////					System.out.println("length of password is : "+pass.length());
//					System.out.println("string is : " +pass.substring(12, 18));
//				}
//			} catch (SQLException e) {
//				// TODO Auto-generated catch block
//				e.printStackTrace();
//			}
//			jd.connClose();
//			
//		}
		
	}