sqlindex.java

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

package sql;
import java.sql.*;

public class SQLIndex {
	public String methodadmin (String id,String password,String property){
		String name = null;
		
		//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+"'and password='"+password+"'and property='"+property+"'");
			if(rs.next())
			{
				Object obj = rs.getObject(2);
				name = obj.toString();
			}
			con.close();
			rs.close();
		}catch(SQLException ex){
			ex.printStackTrace();
			name = null;
		}
		return name;
		
		
	}
	//public String methodname(){
		
	//}

}