userdao.java

用webwork +spring实现的注册管理系统

package cn.ac.ict;

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

public class UserDAO {
	private final String dbDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; // 连接sql数据库的方法

	private final String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=webwork";

	private final String userName = "sa";

	private final String password = "123";

	private Connection con = null;

	public UserDAO() {
		try {
			Class.forName(dbDriver).newInstance(); // 加载数据库驱动
		} catch (Exception ex) {
			System.out.println("数据库加载失败");
		}
	}

	public void add(User user) {
		try {
			Class.forName(dbDriver).newInstance();
			con = DriverManager.getConnection(url, userName, password);
			PreparedStatement ps = con
					.prepareStatement("insert into userinfo values(?,?,?,?,?)");
			ps.setString(1, user.getUsername());
			ps.setString(2, user.getPassword());
			ps.setString(3, user.getVerifyPassword());
			ps.setString(4, user.getEmail());
			ps.setInt(5, user.getAge());
			ps.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (InstantiationException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (IllegalAccessException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

	}

}