adduser.java

本系统为简历系统的Java实现

package dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;


import model.User;

public class Adduser {
	public void adduser(User user) {
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		String url = "jdbc:oracle:thin:@localhost:1521:orcl";
		String n = "scott";
		String p = "tiger";
		Connection conn = null;
		PreparedStatement st = null;
		
		String sql = "insert into users(userid,userpw) values(?,?)";                             
		
		try {
			conn = DriverManager.getConnection(url,n,p);
			conn.setAutoCommit(false);
			st = conn.prepareStatement(sql);
			st.setString(1, user.getUserid());
			st.setString(2, user.getUserpw());
			st.executeUpdate();
			conn.commit();
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally {
			if(conn!=null) {
				try {
					st.close();
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				
			}
		}
	}
}