首页/ 知识库

学生教务管理系统安卓源码

 2025-02-16 12:30:01  阅读 113  评论 0

摘要：这是我用来交作业的程序.虽然不是自己写的.传上来再说了.等我自己的可以用了.再传...package jettangimport java.lang.*import java.awt.*import java.awt.event.*import javax.swing.*import java.sql.*////////////////////////////////////////////////主类public class S

这是我用来交作业的程序.虽然不是自己写的.传上来再说了.

等我自己的可以用了.再传...

学生教务管理系统安卓源码

package jettang

import java.lang.*

import java.awt.*

import java.awt.event.*

import javax.swing.*

import java.sql.*

//////////////////////////////////////////////

//主类

public class STU {

public STU() {

try {

jbInit()

} catch (Exception ex) {

ex.printStackTrace()

}

}

public static void main(String args[]) {

new Frm_Main()

}

private void jbInit() throws Exception {

}

}

//主框架，数据库

class Frm_Main implements ActionListener { //throws IOException

public static final int EXIT_ON_CLOSE = 0

public Jframe frame

public Container c

public JMenuBar menuBar

public JMenu mainMenu1

public JMenu mainMenu2

public JMenu mainMenu3

public JMenuItem subMenu1[] = new JMenuItem[5]

public JMenuItem subMenu2[] = new JMenuItem[7]

public JMenuItem subMenu3[] = new JMenuItem[2]

JButton toolBarButton[] = new JButton[8]

public JToolBar toolBar

//////////////////////////////////////////////

String strTip[] = {"姓名查询...", "添加信息...",

"删除...", "修改...", "修改确认...",

"添加确认...", "删除确认...", "关于产品信息:)"}

//////////////////////////////////////////////

// String id = new String()

String name = new String()

String sex = new String()

String age = new String()

String classid = new String()

String department = new String()

String call = new String()

//////////////////////////////////////////////

Connection con

ResultSet rs

Statement st

// ResultSetmetaData rsmd

// Vector columnHeads=new Vector()

// Vector rows = new Vector()

// Vector currentRow=new Vector()

///////////////////////////////////////////////

public JLabel classidL = new JLabel("班级")

public JLabel nameL = new JLabel("姓名")

public JLabel sexL = new JLabel("性别")

public JLabel ageL = new JLabel("年龄")

public JLabel departmentL = new JLabel("单位")

public JLabel callL = new JLabel("电话")

public JLabel tittleLabel = new JLabel()

//////////////////////////////////////////////

public JTextField classidT = new JTextField()

public JTextField nameT = new JTextField()

public JTextField sexT = new JTextField()

public JTextField ageT = new JTextField()

public JTextField departmentT = new JTextField()

public JTextField callT = new JTextField()

public Jtextarea textT = new Jtextarea()

//////////////////////////////////////////////

//////////////////////////////////////////////

public Frm_Main() {

/////////////////////////////////////////////////

frame = new Jframe("学籍管理系统V1.0")

c = frame.getContentPane()

c.setLayout(null)

menuBar = new JMenuBar()

toolBar = new JToolBar()

toolBar.setFloatable(false)

frame.setJMenuBar(menuBar)

frame.setResizable(false)

////////////////////////////////////////////////

mainMenu1 = new JMenu("管理")

String str1[] = {"添加", "删除", "查询", " ", "关闭"}

for (int i = 0i <5i++) {

if (i == 3) {

mainMenu1.addSeparator()

} else {

subMenu1[i] = new JMenuItem(str1[i])

subMenu1[i].addActionListener(this)

mainMenu1.add(subMenu1[i])

}

}

menuBar.add(mainMenu1)

/////////////////////////////////////////////////

mainMenu2 = new JMenu("操作")

String str2[] = {"查询", "添加", "删除", "修改",

"提交修改", "提交添加", "提交删除"}

for (int i = 0i <7i++) {

subMenu2[i] = new JMenuItem(str2[i])

subMenu2[i].addActionListener(this)

mainMenu2.add(subMenu2[i])

}

menuBar.add(mainMenu2)

/////////////////////////////////////////////////

mainMenu3 = new JMenu("集体查询")

String str3[] = {"按班级...", "按单位..."}

for (int i = 0i <2i++) {

subMenu3[i] = new JMenuItem(str3[i])

subMenu3[i].addActionListener(this)

mainMenu3.add(subMenu3[i])

}

menuBar.add(mainMenu3)

////////////////////////////////////////////////

String strToolBar[] = {"查询", "添加", "删除", "修改", "提交修改",

"提交添加", "提交删除", "关于"}

for (int i = 0i <8i++) {

toolBarButton[i] = new JButton(strToolBar[i])

toolBarButton[i].setToolTipText(strTip[i])

toolBarButton[i].addActionListener(this)

toolBar.add(toolBarButton[i])

}

toolBar.setLocation(0, 0)

toolBar.setSize(400, 30)

c.add(toolBar)

////////////////////////////////////////////////

classidL.setLocation(35, 40)

classidL.setSize(40, 20)

//classidL.setFont(new Font("",Font.BOLD,12))

c.add(classidL)

classidT.setLocation(90, 40)

classidT.setSize(200, 20)

//classidT.setEnabled(false)

c.add(classidT)

nameL.setLocation(35, 70)

nameL.setSize(40, 20)

c.add(nameL)

nameT.setLocation(90, 70)

nameT.setSize(200, 20)

c.add(nameT)

sexL.setLocation(35, 100)

sexL.setSize(40, 20)

c.add(sexL)

sexT.setLocation(90, 100)

sexT.setSize(200, 20)

c.add(sexT)

ageL.setLocation(35, 130)

ageL.setSize(40, 20)

c.add(ageL)

ageT.setLocation(90, 130)

ageT.setSize(200, 20)

c.add(ageT)

departmentL.setLocation(35, 160)

departmentL.setSize(40, 20)

c.add(departmentL)

departmentT.setLocation(90, 160)

departmentT.setSize(200, 20)

c.add(departmentT)

callL.setLocation(35, 190)

callL.setSize(40, 20)

c.add(callL)

callT.setLocation(90, 190)

callT.setSize(200, 20)

c.add(callT)

/////////////////////////////////////////////////

tittleLabel.setText("----------集体查询结果--------")

tittleLabel.setSize(300, 20)

tittleLabel.setLocation(10, 210)

c.add(tittleLabel)

////////////////////////////////////////////

textT.setSize(400, 300)

textT.setLocation(10, 240)

c.add(textT, 14)

///////////////////////////////////////////////

frame.setDefaultCloseOperation(Jframe.EXIT_ON_CLOSE)

frame.setSize(500, 650)

frame.setLocation(200, 200)

frame.setVisible(true)

conDB()

}

//以上是框架设计

//JDBC

public void conDB() {

try {

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver")

} catch (ClassNotFoundException e) {

JOptionPane.showMessageDialog(null, "数据库错误")

}

try {

con = DriverManager.getConnection("jdbc:odbc:jettang", "sa", "")

st = con.createStatement()

} catch (SQLException e) {

JOptionPane.showMessageDialog(null, "数据库连接失败")

}

}

//关闭连接

public void closeDB() {

try {

st.close()

con.close()

} catch (SQLException e) {

JOptionPane.showMessageDialog(null, "数据库关闭失败")

}

}

//事件响应

public void actionPerformed(ActionEvent e) {

//////////////////////////////////////////////

if (e.getSource() == toolBarButton[7]) {

JOptionPane.showMessageDialog(null, "当前版本1.0，designed by qyq &wxm")

}

/////////////////////////////////////////////查询(按姓名)

if (e.getSource() == subMenu2[0] || e.getSource() == toolBarButton[0] ||

e.getSource() == subMenu1[2]) {

String idid = JOptionPane.showInputDialog("请输入学生姓名")

if (idid.trim() != "") {

String strSQL = "select * from stuinfo where name ='" + idid +

"'"

try {

rs = st.executeQuery(strSQL)

int count = 0

while (rs.next()) {

classid = rs.getString("classid")

name = rs.getString("name")

department = rs.getString("department")

sex = rs.getString("sex")

age = rs.getString("age")

call = rs.getString("call")

++count

}

if (count == 0) {

JOptionPane.showMessageDialog(null, "无此信息")

} else {

classidT.setText(classid)

nameT.setText(name)

sexT.setText(sex)

ageT.setText(age)

callT.setText(call)

departmentT.setText(department)

}

} catch (Exception ex) {

JOptionPane.showMessageDialog(null, "查询失败")

}

}

}

/////////////////////////////////////////////关闭

if (e.getSource() == subMenu1[4]) {

frame.dispose()

closeDB()

}

/////////////////////////////////////////////添加

if (e.getSource() == subMenu1[0] || e.getSource() == subMenu2[1] ||

e.getSource() == toolBarButton[1]) {

JOptionPane.showMessageDialog(null, "请输入你添加的信息再点击提交添加键")

classidT.setEnabled(true)

classidT.setText("")

nameT.setText("")

sexT.setText("")

ageT.setText("")

callT.setText("")

departmentT.setText("")

}

/////////////////////////////////////////////提交添加

if (e.getSource() == toolBarButton[5] || e.getSource() == subMenu2[5]) {

if ((classidT.getText().trim()).equals("") ||

(nameT.getText().trim()).equals("") ||

(sexT.getText().trim()).equals("") ||

(ageT.getText().trim()).equals("") ||

(callT.getText().trim()).equals("") ||

(departmentT.getText().trim()).equals("")) {

JOptionPane.showMessageDialog(null, "请先点击添加键")

} else {

classid = classidT.getText()

name = nameT.getText()

sex = sexT.getText()

age = ageT.getText()

call = callT.getText()

department = departmentT.getText()

String strSQL =

"insert into stuinfo(classid,name,sex,age,call,department) values('" +

classid + "','" +

name + "','" + sex + "','" + age + "','" + call + "','" +

department + "')"

try {

st.executeUpdate(strSQL)

} catch (Exception exx) {

JOptionPane.showMessageDialog(null, "添加失败")

return

}

JOptionPane.showMessageDialog(null, "添加成功")

classidT.setText("")

nameT.setText("")

sexT.setText("")

ageT.setText("")

callT.setText("")

departmentT.setText("")

}

}

////////////////////////////////////////////提交修改

if (e.getSource() == subMenu2[4] || e.getSource() == toolBarButton[4]) {

if ((classidT.getText().trim()).equals("") ||

(nameT.getText().trim()).equals("") ||

(sexT.getText().trim()).equals("")

|| (ageT.getText().trim()).equals("") ||

(callT.getText().trim()).equals("") ||

(departmentT.getText().trim()).equals("")) {

JOptionPane.showMessageDialog(null, "请先点击修改键")

return

} else {

classid = classidT.getText()

name = nameT.getText()

sex = sexT.getText()

age = ageT.getText()

call = callT.getText()

department = departmentT.getText()

String strSQL = "update stuinfo set classid='" + classid +

"',sex='" + sex + "',age='" + age + "',call='" +

call + "',department='" + department + "'" +

"where name='" + name + "'"

try {

st.executeUpdate(strSQL)

} catch (Exception exx) {

JOptionPane.showMessageDialog(null, "修改失败")

return

}

JOptionPane.showMessageDialog(null, "修改成功")

classidT.setText("")

nameT.setText("")

sexT.setText("")

ageT.setText("")

callT.setText("")

departmentT.setText("")

}

}

///////////////////////////////////////////////修改

if (e.getSource() == subMenu2[3] || e.getSource() == toolBarButton[3]) {

String idid = JOptionPane.showInputDialog

("请输入你要修改的学生姓名后点击提交修改键确认")

if (idid.trim() != "") {

String strSQL = "select * from stuinfo where name ='" + idid +

"'"

try {

rs = st.executeQuery(strSQL)

int count = 0

while (rs.next()) {

classid = rs.getString("classid")

name = rs.getString("name")

department = rs.getString("department")

sex = rs.getString("sex")

age = rs.getString("age")

call = rs.getString("call")

++count

}

if (count == 0) {

JOptionPane.showMessageDialog(null, "无此信息")

} else {

classidT.setText(classid)

nameT.setText(name)

sexT.setText(sex)

ageT.setText(age)

callT.setText(call)

departmentT.setText(department)

classidT.setEnabled(false)

}

} catch (Exception ex) {

JOptionPane.showMessageDialog(null, "修改失败")

}

}

}

/////////////////////////////////////////////////删除

if (e.getSource() == subMenu2[2] || e.getSource() == toolBarButton[2] ||

e.getSource() == subMenu1[1]) {

String idDel = JOptionPane.showInputDialog

("请输入要删除的学生姓名后点击提交删除键确认")

if (idDel.trim() != "") {

String strSQL = "select * from stuinfo where name ='" + idDel +

"'"

try {

rs = st.executeQuery(strSQL)

int count = 0

while (rs.next()) {

classid = rs.getString("classid")

name = rs.getString("name")

department = rs.getString("department")

sex = rs.getString("sex")

age = rs.getString("age")

call = rs.getString("call")

++count

}

if (count == 0) {

JOptionPane.showMessageDialog(null, "无此信息")

} else {

classidT.setText(classid)

nameT.setText(name)

sexT.setText(sex)

ageT.setText(age)

callT.setText(call)

departmentT.setText(department)

classidT.setEnabled(false)

}

} catch (Exception ex) {

JOptionPane.showMessageDialog(null, "删除失败")

}

}

}

//////////////////////////////////////////////////提交删除

if (e.getSource() == toolBarButton[6] ||

e.getSource() == subMenu2[6]) {

if ((classidT.getText().trim()).equals("") ||

(nameT.getText().trim()).equals("") ||

(sexT.getText().trim()).equals("") ||

(ageT.getText().trim()).equals("") ||

(callT.getText().trim()).equals("") ||

(departmentT.getText().trim()).equals("")) {

JOptionPane.showMessageDialog(null, "请先点击删除键")

return

} else {

name = nameT.getText()

String strSQL = "delete from stuinfo where name='" + name +

"'"

try {

st.executeUpdate(strSQL)

} catch (Exception exx) {

JOptionPane.showMessageDialog(null, "删除失败")

return

}

JOptionPane.showMessageDialog(null, "删除成功")

classidT.setText("")

nameT.setText("")

sexT.setText("")

ageT.setText("")

callT.setText("")

departmentT.setText("")

}

}

//////////////////////////////////////////////集体查询（按班级）

if (e.getSource() == subMenu3[0]) {

classidT.setText("")

nameT.setText("")

sexT.setText("")

ageT.setText("")

callT.setText("")

departmentT.setText("")

if ((classidT.getText().trim()).equals("")) {

String idclass = JOptionPane.showInputDialog("请输入班级")

String strSQL = "select * from stuinfo where classid='" +

idclass +

"'"

try {

rs = st.executeQuery(strSQL)

displayres(rs)

} catch (Exception ex) {

JOptionPane.showMessageDialog(null, "查询失败")

}

} else {

String idclass = classidT.getText()

String strSQL = "select * from stuinfo where classid='" +

idclass +

"'"

try {

rs = st.executeQuery(strSQL)

displayres(rs)

} catch (Exception ex) {

JOptionPane.showMessageDialog(null, "查询失败")

}

}

}

////////////////////////////按单位

if (e.getSource() == subMenu3[1]) {

classidT.setText("")

nameT.setText("")

sexT.setText("")

ageT.setText("")

callT.setText("")

departmentT.setText("")

if ((departmentT.getText().trim()).equals("")) {

String idclass = JOptionPane.showInputDialog("请输入单位")

String strSQL = "select * from stuinfo where department='" +

idclass +

"'"

try {

rs = st.executeQuery(strSQL)

displayres(rs)

} catch (Exception ex) {

JOptionPane.showMessageDialog(null, "查询失败")

}

} else {

String idclass = departmentT.getText()

String strSQL = "select * from stuinfo where department='" +

idclass +

"'"

try {

rs = st.executeQuery(strSQL)

displayres(rs)

} catch (Exception ex) {

JOptionPane.showMessageDialog(null, "查询失败")

}

}

}

}

public void displayres(ResultSet rs1) throws SQLException {

//定位到达第一条记录

boolean moreRecords = rs1.next()

//如果没有记录，则提示一条消息

if (!moreRecords) {

JOptionPane.showMessageDialog(null, "无此记录")

return

}

try {

//获取数据

getNextRow(rs1)

//刷新Table

c.validate()

}

catch (SQLException sqlex) {

sqlex.printStackTrace()

}

}

public void getNextRow(ResultSet rs2) throws

SQLException {

int count = 1

while (rs2.next()) {

name = " 姓名：" + rs2.getString(1)

age = " 年龄：" + rs2.getString(2) + " 单位："

department = rs2.getString(3) + "n"

textT.append(count + "." + name + age + department)

count++

}

}

}

急求java学生信息管理系统源代码，带有连接数据库的，万分感谢

#include <stdio.h>

#include <string.h>

#include <windows.h>

struct student

{

long int num

char name[20]

int age

char sex[4]

char b[30]

char p[15]

}

int n=0

struct student stu[100]

struct student *p

void lr()

void ll()

void cx()

void xg()

void sc()

void main()

{

int z

printf("+---------------------------+n")

printf("| 欢迎使用学生信息管理系统 |n")

printf("+---------------------------+n")

printf("提示：为保证您的操作得到保存，请按正常顺序退出系统^_^n")

do

{

printf("nttt--------------------------------n")

printf("ttt+主菜单|n")

printf("ttt--------------------------------n")

printf("ttt+[1]----录入学生信息 |n")

printf("ttt+[2]----浏览学生信息 |n")

printf("ttt+[3]----查询学生信息 |n")

printf("ttt+[4]----删除学生信息 |n")

printf("ttt+[5]----修改学生信息 |n")

printf("ttt+[0]----退出系统 |n")

printf("ttt--------------------------------n")

printf("请输入您的选择：")

scanf("%d", &z)

system("color 2f")

switch(z)

{

case 0 :break

case 1 :lr()break

case 2 :ll()break

case 3 :cx()break

case 4 :sc()break

case 5 :xg()break

default:printf("n无效选项!")

}

}

while(z!= 0)

}

void lr()

{

int y

if(n==0)

p=stu

do

{

printf("--------------------n")

printf("请输入学生的学号:")

scanf("%ld",&p->num)

printf("请输入学生的姓名:")

scanf("%s",p->name)

printf("请输入学生的年龄:")

scanf("%d",&p->age)

printf("请输入学生的性别:")

scanf("%s",p->sex)

printf("请输入学生的地址:")

scanf("%s",p->b)

printf("请输入学生的电话:")

scanf("%s",p->p)

n++

p++

printf("n1.继续输入.n0.输入完毕.n")

printf("请选择：")

scanf("%d",&y)

}

while(y==1)

printf("提示：输入完毕!你一共输入%d个n",n)

}

void ll()

{

int i,j

if(n!=0)

{ printf("学生总数:%dn", n)

printf("学号t姓名t年龄t性别t地址tt电话n")

printf("-----------------------------------------------------n")

for(i=0i<ni++)

printf("%ldt%st%dt%st%stt%sn",stu[i].num,stu[i].name,stu[i].age,stu[i].sex,stu[i].b,stu[i].p)

}

else printf("提示:无学生数据，请输入数据！")

}

void cx()

{

int c

int w,i,j=0

char name[20]

if(n!=0)

{

do{printf("n")

printf("+--------------------+n")

printf("| 按学号查询 请按 1 |n")

printf("| 按姓名查询 请按 2 |n")

printf("| 取消请按 0 |n")

printf("+--------------------+n")

printf("请输入您的选择：")

scanf("%d", &c)

switch(c)

{

case 0:break

case 1:

printf("请输入学生的学号")

scanf("%ld", &w)

printf("n")

for(i=0i<ni++)

if(stu[i].num==w)

{

printf("n学号t姓名t年龄t性别t地址tt电话n")

printf("%ldt%st%dt%st%stt%sn",stu[i].num,stu[i].name,stu[i].age,stu[i].sex,stu[i].b,stu[i].p)

j=1

}

if(j==0)

printf("提示:没有该学生记录，请核对！")

break

case 2:

printf("请输入学生的姓名：")

scanf("%s", name)

printf("n")

for(i=0i<ni++)

if(strcmp(name,stu[i].name)==0)

{

printf("n学号t姓名t年龄t性别t地址tt电话n")

j=1

printf("%ldt%st%dt%st%stt%sn",stu[i].num,stu[i].name,stu[i].age,stu[i].sex,stu[i].b,stu[i].p)

}

if(j==0)

printf("提示:没有该学生记录，请核对！")

break

default:

printf("n提示:无效选项!")

break

}

}while(c!= 0)

}else printf("提示:无学生数据，请输入数据！")

return

}

void xg()

{

long int num

int i,j,c

if(n!=0)

{

printf("请输入您要修改的学生的学号：")

scanf("%ld", &num)

printf("n")

for(i=0i<ni++)

if(stu[i].num==num)

j=i

do{

printf("请选择您要修改的学生的信息内容：n")

printf("+----------------------+n")

printf("| 姓名 请按 1 |n")

printf("| 年龄 请按 2 |n")

printf("| 性别 请按 3 |n")

printf("| 学号 请按 4 |n")

printf("| 地址 请按 5 |n")

printf("| 电话 请按 6 |n")

printf("| 取消 请按 0 |n")

printf("+----------------------+n")

printf("请输入您的选择：")

scanf("%d", &c)

printf("n")

switch(c)

{

case 0:break

case 1:printf("请输入新姓名：")

scanf("%s",stu[j].name)

break

case 2:printf("请输入新年龄：")

scanf("%d",&stu[j].age)

break

case 3:printf("请输入新性别：")

scanf("%s",stu[j].sex)

break

case 4:printf("请输入新学号：")

scanf("%ld",&stu[j].num)

break

case 5:printf("请输入新地址：")

scanf("%s",stu[j].b)

break

case 6:printf("请输入新电话：")

scanf("%s",stu[j].p)

break

default:

printf("n无效选项!")

break

}

}while(c!= 0)

}else printf("提示:无学生数据，请输入数据！")

}

void sc()

{

long int num

int i,j,e

if(n!=0)

{

printf("学号t姓名t年龄t性别t地址tt电话n")

printf("-----------------------------------------------------n")

for(i=0i<ni++)

printf("%ldt%st%dt%st%stt%sn",stu[i].num,stu[i].name,stu[i].age,stu[i].sex,stu[i].b,stu[i].p)

printf("请输入您要删除的学生的学号：")

scanf("%ld", &num)

printf("n")

for(i=0i<ni++)

if(num==stu[i].num)

j=i

if(j!=(n-1))

{

for(e=i-1e<ne++,j++)

{

stu[j].num=stu[j+1].num

strcpy(stu[j].name,stu[j+1].name)

strcpy(stu[j].sex,stu[j+1].sex)

stu[j].age=stu[j+1].age

strcpy(stu[j].b,stu[j+1].b)

strcpy(stu[j].p,stu[j+1].p)

n--p--

}

}else {n--p--}

printf("提示:删除完毕！")

}elseprintf("提示:无学生数据，请输入数据！")

}

import java.awt.BorderLayout

import java.awt.CardLayout

import java.awt.Container

import java.awt.Font

import java.awt.event.ActionEvent

import java.awt.event.ActionListener

import javax.swing.Icon

import javax.swing.ImageIcon

import javax.swing.JButton

import javax.swing.Jframe

import javax.swing.JLabel

import javax.swing.JMenu

import javax.swing.JMenuBar

import javax.swing.JMenuItem

import javax.swing.JPanel

import javax.swing.JToolBar

import javax.swing.SwingConstants

public class Mainframe extends Jframe implements ActionListener{

InsertPanel ip = null

SelectPanel sp = null

JPanel pframe

JButton jb1,jb2,jb3

JMenuItem jm11,jm21,jm22,jm23,jm31,jm32,jm41,jm42

CardLayout clayout

public Mainframe(String s){

super(s)

JMenuBar mb = new JMenuBar()

this.setJMenuBar(mb)

JMenu m1 = new JMenu("系统")

JMenu m2 = new JMenu("基本信息")

JMenu m3 = new JMenu("成绩")

JMenu m4 = new JMenu("奖惩")

mb.add(m1)

mb.add(m2)

mb.add(m3)

mb.add(m4)

jm11 = new JMenuItem("退出系统")

jm21 = new JMenuItem("输入")

jm22 = new JMenuItem("查询")

jm23 = new JMenuItem("更改")

jm31 = new JMenuItem("输入成绩")

jm32 = new JMenuItem("查询成绩")

jm41 = new JMenuItem("奖励")

jm42 = new JMenuItem("处分")

m1.add(jm11)

m2.add(jm21)

m2.add(jm22)

m2.add(jm23)

m3.add(jm31)

m3.add(jm32)

m4.add(jm41)

m4.add(jm42)

Icon i1 = new ImageIcon()

Icon i2 = new ImageIcon()

Icon i3 = new ImageIcon()

jb1 = new JButton(i1)

jb1.setToolTipText("输入")

jb2 = new JButton(i2)

jb2.setToolTipText("查询")

jb3 = new JButton(i3)

jb3.setToolTipText("退出")

JToolBar tb = new JToolBar("系统工具")

tb.add(jb1)

tb.add(jb2)

tb.add(jb3)

add(tb,BorderLayout.NORTH)

jm11.addActionListener(this)

jm21.addActionListener(this)

jm22.addActionListener(this)

jb1.addActionListener(this)

jb2.addActionListener(this)

jb3.addActionListener(this)

clayout = new CardLayout()

pframe = new JPanel(clayout)

add(pframe)

JPanel mainp = new JPanel(new BorderLayout())

JLabel mainl = new JLabel("学生信息管理平台",SwingConstants.CENTER)

mainl.setFont(new Font("serif",Font.BOLD,30))

mainp.add(mainl)

pframe.add(mainp,"main")

clayout.show(pframe, "main")

}

public void actionPerformed(ActionEvent e){

if(e.getSource() == jm21 || e.getSource() == jb1){

if(ip == null){

ip= new InsertPanel()

pframe.add(ip,"insert")

}

clayout.show(pframe, "insert")

this.setTitle("输入学生信息")

}

else if(e.getSource() == jm22 || e.getSource() == jb2){

if(sp == null){

sp= new SelectPanel()

pframe.add(sp,"select")

}

clayout.show(pframe, "select")

this.setTitle("查询学生信息")

}

else if(e.getSource() == jm11 || e.getSource() == jb3){

System.exit(0)

}

}

}

第二个：

import javax.swing.Jframe

public class MainTest {

public static void main(String [] args){

Mainframe f = new Mainframe("学生信息管理平台")

f.setSize(400,300)

f.setLocation(350,250)

f.setDefaultCloseOperation(Jframe.EXIT_ON_CLOSE)

f.setVisible(true)

}

}

第二个：

import java.sql.Connection

import java.sql.DriverManager

public class MySQLConnection {

static Connection getCon(){

Connection con = null

try{

Class.forName("com.mysql.jdbc.Driver")

con = DriverManager.getConnection("jdbc:mysql://localhost/test","root","123")

}

catch(Exception e){

System.out.println("建立数据库连接遇到异常！")

}

return con

}

}

第四个：

import java.awt.BorderLayout

import java.awt.GridLayout

import java.awt.event.ActionEvent

import java.awt.event.ActionListener

import javax.swing.JButton

import javax.swing.JLabel

import javax.swing.JOptionPane

import javax.swing.JPanel

import javax.swing.JTextField

import javax.swing.SwingConstants

public class SelectPanel extends JPanel implements ActionListener{

JButton jb

JTextField jt

JTextField jt1,jt2,jt3,jt4

public SelectPanel(){

JLabel jl = new JLabel("请输入学号:",SwingConstants.CENTER)

jt = new JTextField()

jb = new JButton("确定")

JPanel jp1 = new JPanel(new GridLayout(1,3))

jp1.add(jl)

jp1.add(jt)

jp1.add(jb)

JLabel j1,j2,j3,j4

j1 = new JLabel("学号:",SwingConstants.CENTER)

j2 = new JLabel("姓名:",SwingConstants.CENTER)

j3 = new JLabel("性别:",SwingConstants.CENTER)

j4 = new JLabel("年龄:",SwingConstants.CENTER)

jt1 = new JTextField(6)

jt1.setEditable(false)

jt2 = new JTextField(6)

jt2.setEditable(false)

jt3 = new JTextField(6)

jt3.setEditable(false)

jt4 = new JTextField(6)

jt4.setEditable(false)

JPanel jp2 = new JPanel(new BorderLayout())

JPanel jp3 = new JPanel(new GridLayout(4,2))

jp2.add(new JLabel(""),BorderLayout.NORTH)

jp3.add(j1)

jp3.add(jt1)

jp3.add(j2)

jp3.add(jt2)

jp3.add(j3)

jp3.add(jt3)

jp3.add(j4)

jp3.add(jt4)

jp2.add(jp3)

this.setLayout(new BorderLayout())

add(jp1,BorderLayout.NORTH)

add(jp2)

jb.addActionListener(this)

}

public void actionPerformed(ActionEvent e){

if(e.getSource() == jb){

String stuNo = jt.getText().trim()

Student s = new Student()

boolean b = true

try{

b = s.selectByStuNo(stuNo)

}

catch(Exception ex){

System.out.println("查询学生信息遇到异常!")

}

if(b){

jt1.setText(s.getStuNo())

jt2.setText(s.getName())

jt3.setText(s.getGender())

int a = s.getAge()

Integer i = new Integer(a)

jt4.setText(i.toString())

}

else{

JOptionPane.showMessageDialog(null, "无此学生!")

}

}

}

}

第五个：

import javax.swing.Jframe

public class SelectTest {

public static void main(String [] args){

Jframe f = new Jframe("查询学生信息")

SelectPanel p = new SelectPanel()

f.add(p)

f.setSize(400,300)

f.setLocation(300,250)

f.setDefaultCloseOperation(Jframe.EXIT_ON_CLOSE)

f.setVisible(true)

}

}

第六个：

import java.sql.Connection

import java.sql.ResultSet

import java.sql.Statement

public class Student {

String stuNo

String name

String gender

int age

public Student(){}

public Student(String stuNo,String name,String gender, int age){

this.stuNo = stuNo

this.name = name

this.gender = gender

this.age = age

}

public String getStuNo(){

return stuNo

}

public void setStuNo(String stuNo){

this.stuNo = stuNo

}

public String getName(){

return name

}

public void setName(String name){

this.name = name

}

public String getGender(){

return gender

}

public void setGender(String gender){

this.gender = gender

}

public int getAge(){

return age

}

public void setAge(int age){

this.age = age

}

public boolean insertStudent(){

boolean b = true

try{

Connection con = MySQLConnection.getCon()

Statement statement = con.createStatement()

String sql = "insert into student values('" + stuNo + "','" + name +"','" + gender + "'," + age + ")"

sql = new String(sql.getBytes("gb2312"),"ISO8859_1")

statement.executeUpdate(sql)

con.close()

}

catch(Exception e){

b = false

System.out.println("插入数据库遇到异常！")

}

return b

}

public boolean selectByStuNo(String stuNo)throws Exception{

boolean b = true

Connection con = MySQLConnection.getCon()

Statement statement = con.createStatement()

String sql = "select * from student where stuNo =" + stuNo

ResultSet rs = statement.executeQuery(sql)

if(rs != null &&rs.next()){

String no = rs.getString(1)

this.setStuNo(no)

String n = rs.getString(2)

n = new String(n.getBytes("ISO8859_1"),"gb2312")

this.setName(n)

String g = rs.getString(3)

g = new String (g.getBytes("ISO8859_1"),"gb2312")

this.setGender(g)

this.setAge(rs.getInt(4))

b = true

}

rs.close()

statement.close()

con.close()

return b

}

}

数据库你自己弄吧，我没时间弄了！初学得多动手哦

以上就是关于急求（教务管理系统 pb9.0 源代码）毕业设计用 高分！全部的内容，如果了解更多相关内容，可以关注，你们的支持是我们更新的动力！

版权声明：我们致力于保护作者版权，注重分享，被刊用文章【学生教务管理系统安卓源码】因无法核实真实出处，未能及时与作者取得联系，或有版权异议的，请联系管理员，我们会立即处理! 部分文章是来自自研大数据AI进行生成,内容摘自(百度百科,百度知道,头条百科,中国民法典,刑法,牛津词典,新华词典,汉语词典,国家院校,科普平台)等数据,内容仅供学习参考,不准确地方联系删除处理!；

原文链接：https://www.yxiso.com/zhishi/1449637.html

上一篇：高考六百分的文科大学
下一篇：上海奉贤区民办院校哪个好

发表评论:

阅读排行
猜你喜欢
热门标签
相关分类
关于我们
院校搜的目标不仅是为用户提供数据和信息，更是成为每一位学子梦想实现的桥梁。我们相信，通过准确的信息与专业的指导，每一位学子都能找到属于自己的教育之路，迈向成功的未来。助力每一个梦想，实现更美好的未来！
快捷菜单
搜索内容
教育资讯
学习方法
院校大全
联系方式
电话：
地址：广东省中山市
Email：beimuxi@protonmail.com

Copyright © 2022 院校搜 Inc. 保留所有权利。 Powered by BEIMUCMS 3.0.3

页面耗时0.0760秒, 内存占用2.05 MB, 访问数据库22次

陕ICP备14005772号-15