java代码实现登录注册sqlserver

package com.mstf.util; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import com.mstf.bean.Student; public class DBUtil { public static final String CLASS="com.microsoft.sqlserver.jdbc.SQLServerDriver"; public static final String URL="jdbc:sqlserver://localhost:1433;DatabaseName=Student"; public static final String USER="sa"; public static final String PWD="123456"; static Connection conn=null; static PreparedStatement ps=null; public static ResultSet rs=null; static { try { Class.forName(CLASS); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } } /** * 通用的增删改 * @return * @throws SQLException */ public static int commonWay(String sql,Object...params) { int result=0; try { conn=getConnection(); ps=conn.prepareStatement(sql); getValues(params); result=ps.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { close(null,ps,conn); } return result; } public static int getUsers(Object...parmas){ int result=0; try { conn=getConnection(); String sql="select * from tbl_user where user_name=? and user_pass=?"; ps=conn.prepareStatement(sql); if(parmas!=null&&parmas.length>0){ for(int i=0;i<parmas.length;i++){ ps.setObject(i+1, parmas[i]); } } rs=ps.executeQuery(); if(rs.next()){ result=1; } return result; } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ close(null, ps, conn); } return 0; } /** * 查询学生信息方法 * @return */ public static List<Student> getAll(){ List<Student> lists=new ArrayList<Student>(); try { conn=getConnection(); String sql="select * from tbl_students"; ps=conn.prepareStatement(sql); rs=ps.executeQuery(); while(rs.next()){ Student s=new Student(); s.setId(rs.getInt("id")); s.setName(rs.getString("stu_name")); s.setType(rs.getString("stu_type")); s.setDate(rs.getString("stu_date")); s.setState(rs.getString("stu_state")); lists.add(s); } return lists; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return null; } /** * 值 * @return * @throws SQLException */ private static void getValues(Object...params) throws SQLException { // TODO Auto-generated method stub for(int i=0;i<params.length;i++) { if(params!=null&&params.length>0) { ps.setObject(i+1, params[i]); } } } /** * 关闭 * @return * @throws SQLException */ private static void close(ResultSet rs, PreparedStatement ps, Connection conn) { // TODO Auto-generated method stub try { if(rs!=null) { rs.close(); } if(rs!=null) { rs.close(); } if(rs!=null) { rs.close(); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public static Connection getConnection() throws SQLException { return DriverManager.getConnection(URL, USER, PWD); } }