quanxian.java

运动会成绩管理系统

package user;



import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.swing.JOptionPane;

public class quanxian 
{ static int q=0; 
public static void main(String args[]){new quanxian();}


public void user_type2(String i) 
	
	{

try{
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    Connection con=DriverManager.getConnection("jdbc:odbc:yundonghui","sa","123");
    Statement ps=con.createStatement();
   ps.executeUpdate("update 用户管理 set 锁定='锁定' where 用户名='"+i+"'");
    

 }
catch (Exception err) { err.printStackTrace();JOptionPane.showMessageDialog(null,"数据库连接出错！"); }

}

public void user_type1(String i) 

{

try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:yundonghui","sa","123");
Statement ps=con.createStatement();
ResultSet rs=ps.executeQuery("select * from 用户管理 where 用户名='"+i+"'");
rs.next();
String msg=rs.getString(3);
if(msg.trim().equals("管理员")) q=1;
else if(msg.trim().equals("普通用户"))  q=2;
else q=0;
}
catch (Exception err) { err.printStackTrace();JOptionPane.showMessageDialog(null,"数据库连接出错！"); }

}

public int get_quanxian()
{return q;}

}