JSP用户注册登录界面

package cn.jhc.service; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import cn.jhc.bean.Group; import cn.jhc.bean.User; public class SurveryService { static{ try { Class.forName("com.mysql.jdbc.Driver"); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public static class SexCount{ public int maleCount; public int femaleCount; public int getMaleCount(){ return maleCount; } public void setMaleCount(int maleCount){ this.maleCount = maleCount; } public int getFemaleCount(){ return maleCount; } public void setFemaleCount(int maleCount){ this.maleCount = maleCount; } } public static SexCount calculateSexCount(){ Connection conn = null; ResultSet rs = null; Statement stat = null; SexCount sexcount =new SexCount(); try { conn = DriverManager.getConnection("jdbc:mysql://localhost/test?user=root&password=123456"); } catch (SQLException e) { // TODO: handle exception } String sql = "select "+ "sum(case option_value when 'male' then 1 else 0 end) as malecount,"+ "sum(case option_value when 'female' then 1 else 0 end) as femalecount "+ "from survey " + "where option_name='sex'"; try { stat= conn.createStatement(); rs = stat.executeQuery(sql); if (rs.first()) { sexcount.maleCount = rs.getInt("malecount"); sexcount.femaleCount= rs.getInt("femalecount"); } } catch (SQLException e) { // TODO: handle exception e.printStackTrace(); } finally{ try{ rs.close(); stat.close(); conn.close(); } catch (SQLException e) { // TODO: handle exception e.printStackTrace(); } } return sexcount; } public static int findIdByUserneme(String username){ ResultSet rs = null; Statement stat = null; int value = 0; Connection conn = getConnection(); String sql = "select id from user where username='"+username+"'"; try { stat= conn.createStatement(); rs = stat.executeQuery(sql); if (rs.first()) { value = rs.getInt(1); }else { value = 0; } } catch (SQLException e) { // TODO: handle exception e.printStackTrace(); } finally{ try{ rs.close(); stat.close(); conn.close(); } catch (SQLException e) { // TODO: handle exception e.printStackTrace(); } } return 0; } public static void saveOPtion(int userId, String optionName, String optionValue) { ResultSet rs = null; Statement stat = null; int value = 0; Connection conn = getConnection(); String sql = "insert into survey(option_name,option_value,user_id)" +"values('"+ optionName + "','"+ optionValue +"',"+userId +")"; try { stat= conn.createStatement(); stat.execute(sql); } catch (SQLException e) { // TODO: handle exception e.printStackTrace(); } finally{ try{ stat.close(); conn.close(); } catch (SQLException e) { // TODO: handle exception e.printStackTrace(); } } System.out.println("a"); } public static List<Group> getGroups() { List<Group> list= new ArrayList<Group>(); Connection connection = getConnection(); ResultSet rs =null; Statement statement = null; String sql = "select id,name from `group`"; try { statement = connection.createStatement(); rs = statement.executeQuery(sql); while(rs.next()) { int id = rs.getInt(1); String name = rs.getString(2); list.add(new Group(id, name)); } }catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { try { statement.close(); connection.close(); } catch (Exception e) { // TODO: handle exception e.printStackTrace(); } } return list; } public static void addUser(User user) { Connection connection = getConnection(); Statement statement = null; String sql = "insert into user(username,password,email,group_id)" +"values('"+user.getName()+"','"+user.getPassword()+"'," +"'"+user.getEmail()+"',"+user.getGroupId()+")"; try { statement=connection.createStatement(); statement.executeUpdate(sql); } catch (SQLException e) { // TODO: handle exception e.printStackTrace(); } finally { try { statement.close(); connection.close(); } catch (Exception e) { // TODO: handle exception e.printStackTrace(); } } } private static Connection getConnection() { Connection conn = null; try { conn = DriverManager.getConnection("jdbc:mysql://localhost/test?user=root&password=123456"); } catch (SQLException e) { // TODO: handle exception e.printStackTrace(); } return conn; } }