sqladdadmin.java

简单的学生管理系统,使用的是SQL2005数据库

package sql;
import java.sql.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class SQLAddAdmin {
	public boolean methodadmin (String id,String password,String property,String name,String age,String gender,String classs,String coursenumber){
		boolean booleanfan = false;
		//String name = null;
		try{
			try {
				Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			} catch (ClassNotFoundException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			Connection con = DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;databaseName=stu","sa","123");
			Statement stmt = con.createStatement();
			ResultSet rs = stmt.executeQuery("select * from users where id='"+id+"'");
			if(rs.next())
			{
				booleanfan = false;
			}
			else
			{
				PreparedStatement ps = con.prepareStatement("insert into users values(?,?,?,?,?,?,?,?)");
				ps.setString(1, id);
				ps.setString(2, name);
				ps.setString(3, password);
				ps.setString(4, property);
				ps.setString(5, age);
				ps.setString(6, gender);
				ps.setString(7, classs);
				ps.setString(8, coursenumber);
				ps.execute();
				booleanfan = true;
			}
			con.close();
			rs.close();
		}catch(SQLException ex){
			ex.printStackTrace();
			name = null;
		}
		return booleanfan;
		
		
	}

}