信息管理系统源代码(源代码管理软件)
admin 发布:2022-12-19 22:48 140
本篇文章给大家谈谈信息管理系统源代码,以及源代码管理软件对应的知识点,希望对各位有所帮助,不要忘了收藏本站喔。
本文目录一览:
- 1、C++学生信息管理系统源代码
- 2、c++学生信息管理系统源代码怎么写
- 3、学生信息管理系统,C++实现的源代码
- 4、学生信息管理系统C++,使用Visual C++ 6.0编写。源代码参考
- 5、急求java学生信息管理系统源代码,带有连接数据库的,万分感谢
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站长 原创,转载请注明出处和附带本文链接;
- 上一篇:包含实现毕业设计选题系统的源代码的词条
- 下一篇:js收缩代码(网页缩放js)
相关推荐
- 05-18信息推广的方式有哪些,信息推广的软件或者平台
- 05-17seo管理软件,seo管理工具
- 05-17广州seo招聘信息,广州seo招聘信息网
- 05-17seo信息是什么,seo内容是什么意思
- 05-15关于黄山seo公司的信息
- 05-09舆情信息在哪里找,舆情通
- 05-07pb超级报表源代码(pb报表工具)[20240507更新]
- 05-07简历源代码可以上传照片的简单介绍[20240507更新]
- 05-07广告切换源代码免费下载(广告切换源代码免费下载安装)[20240507更新]
- 05-06阁楼网源代码(阁楼是什么网站)[20240506更新]
取消回复欢迎 你 发表评论:
- 标签列表
- 最近发表
- 友情链接