文档下载 文档下载导航
设为首页 | 加入收藏
搜索 请输入内容:  
 导航当前位置: 文档下载 > 所有分类 > IT/计算机 > 学生管理系统(JAVA-Mysql)
侵权投诉

学生管理系统(JAVA-Mysql)

MessageDialog(null,se.getMessage());
}
}
//连接到数据库
public Connection getConnection(String dbName)
{
try
{
String mysql = "jdbc:mysql://localhost:3306/";
mysql += dbName;
mysql += "?useUnicode=true&characterEncoding=GBK";
Connection con = DriverManager.getConnection(mysql,"root","5564268");
return con;
}
catch (SQLException se)
{
JOptionPane.showMessageDialog(null,se.getMessage());
return null;
}
}
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt)
{
if(evt.getSource()==jButton1)
{
String userid , password;
userid = jTextField1.getText();System.out.println(userid);
// password = jTextField2.getText();
password = jPassword.getText();// System.out.println(password);
ConnectToMySQL();//连接到数据库
Connection con = getConnection("stusystem");
String sqlTable = "select * from ";
if(con==null)
{
return;
}
if(m_Level==-1)
{
JOptionPane.showMessageDialog(null,"请选择登陆身份");
return;
}
if(m_Level==0)//学生
{
// sqlTable += "stu_login where ID = '"+userid+"' and Pwd = '"+password+"' ";
sqlTable += "stu_login";
}
else if(m_Level == 1)//教师
{
//sqlTable += "tch_login where ID = '"+userid+"' and Pwd = '"+password+"' ";
sqlTable += "tch_login" ;
}
else if(m_Level == 2)//管理员
{
//sqlTable += "sys where ID = '"+userid+"' and Pwd = '"+password+"' ";
sqlTable += "sys";
}
try
{
Statement stmt = (Statement) con.createStatement();
ResultSet rs = stmt.executeQuery(sqlTable);
int row = rs.getRow();
while(rs.next())
{
if((rs.getString("ID").equals(userid))&&(rs.getString("Pwd").equals(password)))
{
this.dispose();
JOptionPane.showMessageDialog(null,"登录成功");
Main main = new Main();
main.m_myconn = con;
main.m_Level1 = m_Level;
main.m_userid = userid;
main.InitMenu();
main.login = this;
main.setVisible(true);
stmt.close();
rs.close();
return;
}

}
JOptionPane.showMessageDialog(null,"登录失败");
stmt.close();
rs.close();
return;
}
catch (SQLException se)
{
JOptionPane.showMessageDialog(null,se.getMessage());
}
}
else
{
dispose();
//System.exit(0);
}
}
//密码处理事件
private void jPasswordActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}

public static void main(String args[])
{

java.awt.EventQueue.invokeLater(new Runnable()
{

public void run()

上一页第4页

你可能喜欢

  • 管理系统SQL
  • 成绩管理系统java
  • MySQL命令
  • 学生信息管理系统java课程设计
  • 复习笔记
  • Java基础
  • mysql教程

热门文档

相关文档

站点地图 | 文档上传 | 侵权投诉 | 手机版
本站所有资源均来自互联网,本站只负责收集和整理,均不承担任何法律责任,如有侵权等其它行为请联系我们.
文档下载 Copyright 2013 doc.guandang.net All Rights Reserved.  -  email