当前位置:首页 > 代码 > 正文

信息管理系统源代码(源代码管理软件)

admin 发布:2022-12-19 22:48 140


本篇文章给大家谈谈信息管理系统源代码,以及源代码管理软件对应的知识点,希望对各位有所帮助,不要忘了收藏本站喔。

本文目录一览:

C++学生信息管理系统源代码

说实话,看到LZ的问题时,还蛮感兴趣的,但是看到给的分数时,我的兴趣全没了。所以,LZ,你明白我说的意思了吧。

c++学生信息管理系统源代码怎么写

#include iostream

#include iomanip

#include string

using namespace std;

typedef struct student {

unsigned m_id;

string m_name;

unsigned m_age;

string m_sex;

string m_address;

string m_contact;

string m_dormitory;

struct student *m_next;

}student;

class CStudent {

private :

student *head;

public :

CStudent() {

head = new student;

head-m_id = 0;

head-m_name = "noname";

head-m_next = NULL;

}

~CStudent() {

student *p = head,*q;

while(p) {

q = p;

p = q-m_next;

delete q;

}

}

student readdata(int model); // model = 1:不读取学号,2:不读取姓名,其他,读取所有信息

void entering();

bool insert(const student astu);

student *findid(unsigned id) const;

student *findname(const string name) const;

student *findsex(const string sex) const;

student *finddormitory(const string dormitory) const;

unsigned boys() const;

unsigned girls() const;

unsigned headcount() const;

bool eraseid();

bool erasename();

bool modifyid();

bool modifyname();

void Show() const;

void query() const;

void friend statistics(const CStudent aclss);

void friend erase(CStudent aclss);

void friend modify(CStudent aclss);

};

string readstring() {

string str;

while(cin.get() != '\n');

cin str;

return str;

}

student CStudent::readdata(int model) {

student tmp;

if(model != 1) { cout "学 号: "; cin tmp.m_id; }

if(model != 2) { cout "姓 名: "; tmp.m_name = readstring(); }

cin tmp.m_age;

cout "性 别: ";

tmp.m_sex = readstring();

cout "住 址: ";

tmp.m_address = readstring();

cout "联系方式: ";

tmp.m_contact =readstring();

cout "寝 室: ";

tmp.m_dormitory = readstring();

return tmp;

}

void CStudent::entering() {

student tmp;

cout "学号(0 to return): ";

cin tmp.m_id;

while(tmp.m_id) {

if(findid(tmp.m_id) == NULL) {

cout "姓 名: ";

tmp.m_name = readstring();

cout "年 龄: ";

cin tmp.m_age;

cout "性 别: ";

tmp.m_sex = readstring();

cout "住 址: ";

tmp.m_address = readstring();

cout "联系方式: ";

tmp.m_contact = readstring();

cout "寝 室: ";

tmp.m_dormitory = readstring();

insert(tmp);

}

else cout "重复的学号:" tmp.m_id endl;

cout "学号(0 to return): ";

cin tmp.m_id;

}

}

student *CStudent::findid(unsigned id) const {

student *p;

for(p = head; p-m_next; p = p-m_next)

if(p-m_next-m_id == id) return p;

return NULL;

}

student *CStudent::findname(const string name) const {

student *p;

for(p = head; p-m_next; p = p-m_next)

if(p-m_next-m_name == name) return p;

return NULL;

}

student *CStudent::findsex(const string sex) const {

student *p;

for(p = head; p-m_next; p = p-m_next)

if(p-m_next-m_sex == sex) return p;

return NULL;

}

student *CStudent::finddormitory(const string dormitory) const {

student *p;

for(p = head; p-m_next; p = p-m_next)

if(p-m_next-m_dormitory == dormitory) return p;

return NULL;

}

bool CStudent::insert(const student astu) {

student *newnode,*p = head;

if(p-m_next == NULL) {

p-m_next = new student(astu);

p-m_next-m_next = NULL;

return true;

}

while(p-m_next) {

if(p-m_next-m_id == astu.m_id) {

cout "重复的学号,插入失败!\n";

return false;

}

if(p-m_next-m_id astu.m_id) {

newnode = new student(astu);

newnode-m_next = p-m_next;

p-m_next = newnode;

return true;

}

p = p-m_next;

}

p-m_next = new student(astu);

p-m_next-m_next = NULL;

return true;

}

unsigned CStudent::boys() const {

unsigned cnt = 0;

student *p;

for(p = head-m_next; p; p = p-m_next)

if(p-m_sex == "男") ++cnt;

return cnt;

}

unsigned CStudent::girls() const {

unsigned cnt = 0;

student *p;

for(p = head-m_next; p; p = p-m_next)

if(p-m_sex == "女") ++cnt;

return cnt;

}

unsigned CStudent::headcount() const {

unsigned cnt = 0;

student *p;

for(p = head-m_next; p; p = p-m_next,++cnt);

return cnt;

}

bool CStudent::eraseid() {

student *q,*p;

unsigned id;

cout "输入要删除的学号:";

cin id;

p = findid(id);

if(p == NULL) {

cout "没有找到学号是\"" id "\"的学生,删除失败!\n";

return false;

}

q = p-m_next;

p-m_next = q-m_next;

delete q;

return true;

}

bool CStudent::erasename() {

student *q,*p;

string name;

cout "输入要删除人的姓名:";

name = readstring();

p = findname(name);

if(p == NULL) {

cout "没有找到姓名是\"" name "\"的学生,删除失败!\n";

return false;

}

q = p-m_next;

p-m_next = q-m_next;

delete q;

return true;

}

bool CStudent::modifyid() {

student tmp,*p;

unsigned id;

cout "输入要修改的学号:";

cin id;

p = findid(id);

if(p == NULL) {

cout "没有找到学号是\"" id "\"的学生,修改失败!\n";

return false;

}

tmp = readdata(1);

tmp.m_id = id;

*p = tmp;

return true;

}

bool CStudent::modifyname() {

student *p,tmp;

string name;

cout "输入要修改人的姓名:";

name = readstring();

p = findname(name);

if(p == NULL) {

cout "没有找到姓名是\"" name "\"的学生,修改失败!\n";

return false;

}

tmp = readdata(2);

tmp.m_name = name;

*p = tmp;

return true;

}

int menu() {

int choice;

do {

system("cls");

cout "\t****************************\n";

cout "\t* 学生基本信息管理系统 *\n";

cout "\t*==========================*\n";

cout "\t* 1、录入学生信息 *\n";

cout "\t* 2、显示学生信息 *\n";

cout "\t* 3、查询学生信息 *\n";

cout "\t* 4、添加学生信息 *\n";

cout "\t* 5、统计学生信息 *\n";

cout "\t* 6、删除学生信息 *\n";

cout "\t* 7、修改学生信息 *\n";

cout "\t* 0、退出管理系统 *\n";

cout "\t****************************\n";

cout "\n\t请选择:";

cin choice;

}while(choice 0 || choice 7);

return choice;

}

void show(student *p) {

cout p-m_id " " p-m_name " " p-m_age " ";

cout p-m_sex " " p-m_address " ";

cout p-m_contact " " p-m_dormitory endl;

}

void CStudent::Show() const {

student *p;

cout "----------------------------------------------------------\n";

for(p = head-m_next; p; p = p-m_next) show(p);

cout "----------------------------------------------------------\n";

system("pause");

}

void CStudent::query() const {

int select;

unsigned id;

string name;

student *p;

cout "1、按学号查询\n2、按姓名查询\n0、返回\n";

cin select;

switch(select) {

case 1 : cout "请输入学号:"; cin id;

if(p = findid(id)) show(p-m_next);

break;

case 2 : cout "请输入姓名:"; name = readstring();

if(p = findname(name)) show(p-m_next);

break;

case 0 : return;

default : cout "选择错误。\n";

}

system("pause");

}

void statistics(const CStudent a) {

unsigned total = a.headcount();

unsigned boys = a.boys();

unsigned girls = a.girls();

cout "学生总数:" total "人。\n";

cout "其中,男生:" boys "名。";

cout "女生:" girls "名。\n";

system("pause");

}

void erase(CStudent a) {

int select;

unsigned id;

string name;

student *p,*q;

cout "1、按学号删除\n2、按姓名删除\n0、返回\n";

cin select;

switch(select) {

case 1 : cout "请输入学号:"; cin id;

if(p = a.findid(id)) {

q = p-m_next;

p-m_next = q-m_next;

delete q;

cout "成功删除 " id " 的信息。\n";

}

break;

case 2 : cout "请输入姓名:"; name = readstring();

if(p = a.findname(name)) {

q = p-m_next;

p-m_next = q-m_next;

delete q;

cout "成功删除 " name " 的信息。\n";

}

break;

case 0 : return;

default : cout "选择错误。\n";

}

system("pause");

}

void modify(CStudent a) {

int select;

cout "1、按学号修改\n2、按姓名修改\n0、返回\n";

cin select;

switch(select) {

case 1 : if(a.modifyid()) cout "修改成功。\n"; break;

case 2 : if(a.modifyname()) cout "修改成功。\n"; break;

case 0 : return;

default : cout "选择错误。\n";

}

system("pause");

}

int main() {

CStudent a;

int an;

do {

an = menu();

switch(an) {

case 1 : a.entering(); break;

case 2 : a.Show(); break;

case 3 : a.query(); break;

case 4 : a.entering(); break;

case 5 : statistics(a); break;

case 6 : erase(a); break;

case 7 : modify(a); break;

case 0 : break;

default : cout "选择错误。\n"; break;

}

}while(an);

return 0;

}

学生信息管理系统,C++实现的源代码

#include iostream

#includefstream

#includestring

using namespace std;

class student

{

public:

void setdate();//录入

void chazhao();//查找

void showdate();//输出

//void change();//修改

void del();//删除

private:

student *next,*head;

string name;

int age;

};

void student::setdate()

{

int n;

cout"请输入所要录入的学生人数:"endl;

cinn;

student *p,*s;

int i;

for(i=0;in;i++)

{

p=new student;

cout"分别输入学生的年龄和姓名:";

cinp-agep-name;

if(i==0)

head=s=p;

else s-next=p;

p-next=NULL;

s=p;

}

ofstream fout("d://program//test.txt",ios::out);

if(!fout){cout"cannot open file.";}

for(i=0;in;i++)

{

fouthead-age" "head-nameendl;

head=head-next;

}

fout.close();

}

void student::showdate()

{

student *p;

ifstream fout1("d://program//test.txt",ios::in);

if(!fout1){cout"cannot open file.\n";exit(1);}

p=new student;

while(fout1.good())

{

fout1p-agep-name;

if(fout1.good())

coutp-age" "p-nameendl;

}

fout1.close();

}

void student::chazhao()

{

string a;

int k=0;

cout"输入你要查找的学生的姓名:\n";

cina;

student *p;

ifstream fout1("d://program//test.txt",ios::in);

if(!fout1){cout"cannot open file.\n";exit(1);}

while(fout1.good())

{

p=new student;

fout1p-agep-name;

if(p-name==a)

{

coutp-age" "p-nameendl;

k=1;

break;

}

}

if(k==0) cout"你所查找的学生不存在!!!\n";

fout1.close();

}

void student::del()

{

student *p,*op;

string namea;

cout"输入你所要删除的学生的姓名:\n";

cinnamea;

ifstream fout("d://program//test.txt",ios::in);

if(!fout){cout"cannot open file.";}

while(fout.good())

{

p=new student;

int i=0;

foutp-agep-name;

if(p-name==nameai==0)

{

delete p;

break;

}

else if(p-name==nameai!=0)

{

op-next=p-next;

delete p;

break;

}

else

{

op=p;

p=p-next;

}

i++;

}

cout"删除成功!!!\n";

fout.close();

}

int main()

{

student duixiang;

int m;

cout"-------------欢迎使用我的成绩管理系统!\n";

cout"--------------------1.录入学生信息\n";

cout"--------------------2.输出学生信息\n";

cout"--------------------3.查找学生信息\n";

cout"--------------------4.删除学生信息\n";

cout"--------------------5.退出系统\n";

cout"请选择所要执行的操作(1~4):\n";

cinm;

switch(m)

{

case 1:duixiang.setdate();

case 3:duixiang.chazhao();

//case 3:duixiang.change();break;

case 4:duixiang.del();break;

case 2:duixiang.showdate();

case 5:break;

}

return 0;

}

/*void menu::shanchu() {

system("cls") ;

char ch[10] ;

cout"\n *** 删除信息 ***\n"endl ;

cout"\n 请输入要删除人的姓名 : " ;

cinch ;

addbook *p , *p1 ;

p1 = head ;

while( p1 )

{

// coutch" "p1-nameendl ; // 查找结点

if(strcmp( p1-name , ch ) == 0 )

break ;

else {

p = p1 ; // 标记相连结点位置,删除后可连接

p1 = p1-next ;

}

}

if( p1!= NULL )

{ // 判断结点是否为空

cout"所要删除的名片的信息如下,请确认!:\n"endl ;

output(p1) ; // 函数输出名片信息

cout"请再次确认是否删除该信息!!!(Y/N) :" ;

char c[10] ;

while(1)

{

cinc ;

if( toupper(c[0]) == 'Y' c[1]=='\0' )

{

if( p1 == head )

{ // 判断是否是第一个结点

head = p1-next ;

delete p1 ;

}

else

{

p-next = p1-next ; // 已标记结点的连接

delete p1 ;

}

cout"\t\t *** 删除成功 *** \t\t\n" ;

system("cls") ;

cout"\n\n\n\n\n" ;

cout"\t\t *** 是否继续删除 *** \t\t\n" ;

cout"*** 请确认(Y/N) :" ;

while(1)

{

cinc;

if( toupper(c[0]) == 'Y' c[1]=='\0' )

shanchu() ;

else if( toupper(c[0]) == 'N' c[1]=='\0' )

return ;

else cout"输入错误 , 请重新输入(Y/N) :" ;

}

}

else if( toupper(c[0]) == 'N' c[1]=='\0' ) return ;

else cout"输入错误 , 请重新输入(Y/N) :" ;

}

}

else {

cout"\n\n\n未找到该信息!!!"endl ;

system("pause") ;

return ;

}

}

*/

学生信息管理系统C++,使用Visual C++ 6.0编写。源代码参考

#includestdio.h

#includestdlib.h

#includestring.h

typedef struct list{

    struct list *next;

int num; //学号

    char name[30];//姓名

int age; //年龄

char sex; //性别

    char addr[50];//地址

    char mobile[11];//号码 

int department; //寝室号

}user;

 

void insert(user *h);

void edit(user *h);

void del(user *h);

void S_byName(user *h);

void S_byNum(user *h);

void display(user *h);

 

int main()

{

    int flag;

    user *head=(user *)malloc(sizeof(user));

    head-next=NULL;

    while(1)

    {

        printf("    1、添加新用户信息\n");

        printf("    2、修改用户信息\n");

        printf("    3、删除已有用户信息\n");

        printf("    4、根据用户名查询信息\n");

        printf("    5、根据学号查询信息\n");

        printf("    6、显示全部用户信息\n");

printf("    7、清屏\n");

        printf("    8、退出\n");

        printf("请选择:");

        scanf("%d",flag);

        if(flag==1)

            insert(head);

        else if(flag==2)

            edit(head);

        else if(flag==3)

            del(head);

        else if(flag==4)

            S_byName(head);

        else if(flag==5)

             S_byNum(head);

        else if(flag==6)

            display(head);

else if(flag==7)

system("clear");

        else if(flag==8)

            return 0;

        else

            printf("输入有误,请重新选择!\n");

    }

}

void insert(user *h)

{

    user *p=(user *)malloc(sizeof(user));

    p-next=h-next;

    h-next=p;

printf("请输入新增用户学号:");

scanf("%d",p-num);

    printf("请输入新增用户名称(最多30个字):");

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

printf("请输入新增用户年龄:");

scanf("%d",p-age);

printf("请输入新增用户性别:");

scanf("%c",p-sex);

    printf("请输入新增用户的家庭住址(最多50字):");

    scanf("%s",p-addr);

    printf("请输入新增用户的电话号码(11位数):");

    scanf("%s",p-mobile);

printf("请输入新增用户寝室号:");

scanf("%d",p-department);

    printf("新用户记录成功添加:%d %s %d %c %s  %s %d\n",p-num,p-name,p-age,p-sex, p-addr,p-mobile, p-department);

}

void edit(user *h)

{

    int num;

    int flag=0;

    user *lh=h-next;

    printf("输入要修改用户的学号:");

    scanf("%d",num);

    while(lh)

    {

        if(num == lh-num)

        {

            flag=1;

printf("请输入新增用户学号:");

scanf("%d",lh-num);

printf("请输入新增用户名称(最多30个字):");

scanf("%s",lh-name);

printf("请输入新增用户年龄:");

scanf("%d",lh-age);

printf("请输入新增用户性别:");

scanf("%c",lh-sex);

printf("请输入新增用户的家庭住址(最多50字):");

scanf("%s",lh-addr);

printf("请输入新增用户的电话号码(11位数):");

scanf("%s",lh-mobile);

printf("请输入新增用户寝室号:");

scanf("%d",lh-department);

printf("新用户记录成功添加:%d %s %d %c %s  %s %d\n",lh-num,lh-name,lh-age,lh-sex, lh-addr,lh-mobile, lh-department);

            break;

        }

        lh=lh-next;

    }

    if(!flag)

        printf("不存在这样的用户\n\n");

}

void S_byName(user *h)

{

    char name[30];

    int flag=0;

    user *lh=h-next;

    printf("输入要查找的用户名称:");

    scanf("%s",name);

    while(lh)

    {

        if(strcmp(name,lh-name)==0)

        {

            flag=1;

            printf("用户信息为:%d %s %d %c %s  %s %d\n",lh-num,lh-name,lh-age,lh-sex, lh-addr,lh-mobile, lh-department);

            break;

        }

        lh=lh-next;

    }

    if(!flag)

        printf("用户名不存在\n\n");

}

void S_byNum(user *h)

{

    int num;

    int flag=0;

    user *lh=h-next;

    printf("输入要查找的学号:");

    scanf("%d",num);

    while(lh)

    {

        if(num == lh-num)

        {

            flag=1;

             printf("用户信息:%d %s %d %c %s  %s %d\n",lh-num,lh-name,lh-age,lh-sex, lh-addr,lh-mobile, lh-department);

            break;

        }

        lh=lh-next;

    }

    if(!flag)

        printf("找不到匹配的号码\n\n");

}

void display(user *h)

{

    user *lh=h-next;

    int i=1;

    while(lh)

    {

        printf("第%d条用户信息:%d %s %d %c %s  %s %d\n",i,lh-num,lh-name,lh-age,lh-sex, lh-addr,lh-mobile, lh-department);

        lh=lh-next;

        i++;

    }

    printf("\n");

}

void del(user *h)

{

    int num;

    int flag=0;

    user *lh=h;

    printf("输入要删除的用户学号:");

    scanf("%d",num);

    while(lh-next)

    {

        if(num == lh-next-num)

        {

            flag=1;

            printf("删除用户成功:%d %s %d %c %s  %s %d\n",lh-num,lh-name,lh-age,lh-sex, lh-addr,lh-mobile, lh-department);

            lh-next=lh-next-next;

            break;

        }

        lh=lh-next;

    }

    if(!flag)

        printf("用户名不存在\n\n");

}

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

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;

}

}

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

关于信息管理系统源代码和源代码管理软件的介绍到此就结束了,不知道你从中找到你需要的信息了吗 ?如果你还想了解更多这方面的信息,记得收藏关注本站。

版权说明:如非注明,本站文章均为 AH站长 原创,转载请注明出处和附带本文链接;

本文地址:http://ahzz.com.cn/post/28466.html


取消回复欢迎 发表评论:

分享到

温馨提示

下载成功了么?或者链接失效了?

联系我们反馈

立即下载