学生注册查询代码java 学生注册学号在哪查

急求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);

}

}

}

第二个学生注册查询代码java：

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("建立数据库连接遇到异常学生注册查询代码java！");

}

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;

}

}

数据库学生注册查询代码java你自己弄吧学生注册查询代码java，学生注册查询代码java我没时间弄了！初学得多动手哦

相关问答

Q1: 初学JAVA 怎么用XML建立一个学生信息管理系统啊 管理员可以注册和登录 有增删改查功能 不需要图形化界面

用DOM4J话基本上是对XML信息读取 以及对XML写。

DOM4J写学生注册查询代码java的话先在内存中生成一个DOM树 然后再用流写入XML中

读学生注册查询代码java的话先从XML中读取 然后 逐个建对象赋值生成对象集合（List集合）。然后对其集合判断（用来登陆）学生注册查询代码java，修改集合的对象（用来修改学生信息）。删除，改等等操作再简单不过了。

我这里有对XML读取 写入的代码 其他的自己完成吧

import java.io.IOException;

import java.io.StringWriter;

import java.io.Writer;

import java.util.ArrayList;

import java.util.Iterator;

import java.util.List;

import org.dom4j.Document;

import org.dom4j.DocumentHelper;

import org.dom4j.Element;

import org.dom4j.io.OutputFormat;

import org.dom4j.io.SAXReader;

import org.dom4j.io.XMLWriter;

import com.cssl.entity.Users;

/**

 * Document Object Model for Java

 * @author Administrator

 *

 */

public class Dom4jDemo {

    

    /**

     * DOM4j解析

     * @return

     * @throws Exception

     */

    public static ListUsers readXml() throws Exception{

        ListUsers list = new ArrayListUsers();

        

        //dom4j解析器

        SAXReader reader = new SAXReader();

        //解析文档

        Document doc = reader.read("usersinfo.xml");

        Element root = doc.getRootElement();

        IteratorElement it = root.elementIterator("user");

        

        while(it.hasNext()){

            Element elt = it.next();

            Users u = new Users();

            u.setId(Integer.parseInt(elt.attributeValue("id")));

            

            IteratorElement ch = elt.elementIterator();

            u.setUsername(ch.next().getTextTrim());

            u.setPassword(ch.next().getTextTrim());

            list.add(u);

        }

        

        return list;

    }

    

    /**

     * DOM4j写

     * @param list

     * @throws Exception

     */

    public static void writeXml(ListUsers list) throws Exception{

        //构建文档树

        Document doc = DocumentHelper.createDocument();

        Element root = doc.addElement("users");        

        for(Users u : list){

            Element user = root.addElement("user").addAttribute("id", u.getId()+"");

            user.addElement("username").addText(u.getUsername());

            user.addElement("password").setText(u.getPassword());

        }

        

        Writer out = new StringWriter();

        //使用xml输出流写出去

        XMLWriter writer = new XMLWriter(out,OutputFormat.createPrettyPrint());

        writer.write(doc);

        

        System.out.println(out);

        

        out.close();

    }

    /**

     * @param args

     * @throws Exception

     */

    public static void main(String[] args) throws Exception {

        ListUsers list = readXml();

        for(Users u : list){

            System.out.println(u.getId()+"\t"+u.getUsername()+"1\t"+u.getPassword());

        }

        writeXml(list);

    }

}

下面我写这个xml文件

?xml version="1.0" encoding="UTF-8"?

users

    user id="1"

        username小何  /username

        password123 /password

    /user

    user id="2"

        username小曹/username

        password456/password

    /user

    user id="3"

        username小龚/username

        password789/password

    /user

/users

Q2: 求java学生管理系统源代码 急！！！

完成了，希望能帮到你

刚开始会叫你输入编号选择功能

import java.io.*;

public class student {

public static void main(String args[]) throws IOException{

int[] stud = {77,99,55,46,82,75,65,31,74,85};

System.out.println("请选择功能：");//输入编号选择功能

System.out.println("1、输入学号，查询该学生成绩：");

System.out.println("2、输入成绩，查询学生学号：");

System.out.println("3、输入学号，删除该学生成绩");

System.out.println("请选择编号：");

BufferedReader td = new BufferedReader(new InputStreamReader(System.in));

String temp = td.readLine();

int choice = Integer.valueOf(temp);

if(choice == 1){//一为查询学生成绩

System.out.println("请输入学号：");

BufferedReader sd = new BufferedReader(new InputStreamReader(System.in));

String temp_sd = sd.readLine();

int No = Integer.valueOf(temp_sd);

System.out.print("学号为 "+No+" 的学生成绩为： " + stud[No-1] +"分");

}

if(choice == 2){//二为查询学生编号

System.out.println("请输入成绩：");

BufferedReader sd = new BufferedReader(new InputStreamReader(System.in));

String chengji = sd.readLine();

int temp_cj = Integer.valueOf(chengji);

for(int i=0;istud.length;i++){

if(temp_cj == stud[i]){

System.out.print("成绩为 "+ temp_cj+ "的学生的学号为: "+(i+1));

}

}

}

if(choice == 3){//三为删除操作

System.out.println("请输入学号：");

BufferedReader sd = new BufferedReader(new InputStreamReader(System.in));

String temp_sd = sd.readLine();

int No = Integer.valueOf(temp_sd);

stud[No-1]=0;//直接赋值为0，不删除学生

System.out.print("学号为 "+No+" 的学生成绩为： " + stud[No-1] +"分");

}

}

}

Q3: 学生信息综合查询管理系统 JAVA程序编写

package test;

import java.sql.*;

import java.awt.*;

import javax.swing.*;

import java.awt.event.*;

import javax.swing.border.*;

import javax.swing.JOptionPane;

class Add extends Panel implements ActionListener{

Connection con;

Statement sql;

Button b1,b2;

TextField tf1,tf2,tf3,tf4,tf5,tf6;

Box baseBox,bv1,bv2;

Add(){

try{

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

}

catch(ClassNotFoundException e){}

try{

con=DriverManager.getConnection("jdbc:odbc:data","","");

sql=con.createStatement();

}

catch(SQLException ee){}

setLayout(new BorderLayout());

Panel p1=new Panel();

Panel p2=new Panel();

tf1=new TextField(16);

tf2=new TextField(16);

tf3=new TextField(16);

tf4=new TextField(16);

tf5=new TextField(16);

tf6=new TextField(16);

b1=new Button("录入");

b1.setBackground(Color.green);

b2=new Button("重置");

b2.setBackground(Color.green);

b1.addActionListener(this);

b2.addActionListener(this);

p1.add(b1);

p1.add(b2);

bv1=Box.createVerticalBox();

bv1.add(new Label("学号"));

bv1.add(Box.createVerticalStrut(8));

bv1.add(new Label("姓名"));

bv1.add(Box.createVerticalStrut(8));

bv1.add(new Label("性别"));

bv1.add(Box.createVerticalStrut(8));

bv1.add(new Label("专业"));

bv1.add(Box.createVerticalStrut(8));

bv1.add(new Label("年级"));

bv1.add(Box.createVerticalStrut(8));

bv1.add(new Label("出生"));

bv1.add(Box.createVerticalStrut(8));

bv2=Box.createVerticalBox();

bv2.add(tf1);

bv2.add(Box.createVerticalStrut(8));

bv2.add(tf2);

bv2.add(Box.createVerticalStrut(8));

bv2.add(tf3);

bv2.add(Box.createVerticalStrut(8));

bv2.add(tf4);

bv2.add(Box.createVerticalStrut(8));

bv2.add(tf5);

bv2.add(Box.createVerticalStrut(8));

bv2.add(tf6);

bv2.add(Box.createVerticalStrut(8));

baseBox=Box.createHorizontalBox();

baseBox.add(bv1);

baseBox.add(Box.createHorizontalStrut(10));

baseBox.add(bv2);

p2.add(baseBox);

add(p1,"South");

add(p2,"Center");

setSize(350,300);

setBackground(Color.pink);

}

public void actionPerformed(ActionEvent e){

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

try{ insert();}

catch(SQLException ee){}

JOptionPane.showMessageDialog(this,"数据已入库!","提示对话框",JOptionPane.INFORMATION_MESSAGE);

}

else if(e.getSource()==b2){

tf1.setText(" ");

tf2.setText(" ");

tf3.setText(" ");

tf4.setText(" ");

tf5.setText(" ");

tf6.setText(" ");

}

}

public void insert() throws SQLException{

String s1="'"+tf1.getText().trim()+"'";

String s2="'"+tf2.getText().trim()+"'";

String s3="'"+tf3.getText().trim()+"'";

String s4="'"+tf4.getText().trim()+"'";

String s5="'"+tf5.getText().trim()+"'";

String s6="'"+tf6.getText().trim()+"'";

String temp="INSERT INTO jesse VALUES ("+s1+","+s2+","+s3+","+s4+","+s5+","+s6+")";

con=DriverManager.getConnection("jdbc:odbc:data","","");

sql.executeQuery(temp);

con.close();

}

}

class Query extends Panel implements ActionListener{

Connection con;

Statement sql;

TextField t1,t2,t3,t4,t5,t6;

Button b;

Box baseBox,bv1,bv2;

int flag=0;

Query(){

try{

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

}

catch(ClassNotFoundException e){}

try{

con=DriverManager.getConnection("jdbc:odbc:data","","");

sql=con.createStatement();

}

catch(SQLException ee){}

setLayout(new BorderLayout());

b=new Button("查询");

b.setBackground(Color.orange);

b.addActionListener(this);

t1=new TextField(8);

t2=new TextField(16);

t3=new TextField(16);

t4=new TextField(16);

t5=new TextField(16);

t6=new TextField(16);

t2.setEditable(false);

t3.setEditable(false);

t4.setEditable(false);

t5.setEditable(false);

t6.setEditable(false);

Panel p1=new Panel(),p2=new Panel();

p1.add(new Label("输入要查询的学号"));

p1.add(t1);

p1.add(b);

bv1=Box.createVerticalBox();

bv1.add(new Label("姓名"));

bv1.add(Box.createVerticalStrut(8));

bv1.add(new Label("性别"));

bv1.add(Box.createVerticalStrut(8));

bv1.add(new Label("专业"));

bv1.add(Box.createVerticalStrut(8));

bv1.add(new Label("年级"));

bv1.add(Box.createVerticalStrut(8));

bv1.add(new Label("出生"));

bv1.add(Box.createVerticalStrut(8));

bv2=Box.createVerticalBox();

bv2.add(t2);

bv2.add(Box.createVerticalStrut(8));

bv2.add(t3);

bv2.add(Box.createVerticalStrut(8));

bv2.add(t4);

bv2.add(Box.createVerticalStrut(8));

bv2.add(t5);

bv2.add(Box.createVerticalStrut(8));

bv2.add(t6);

bv2.add(Box.createVerticalStrut(8));

baseBox=Box.createHorizontalBox();

baseBox.add(bv1);

baseBox.add(Box.createHorizontalStrut(10));

baseBox.add(bv2);

p2.add(baseBox);

add(p1,"North");

add(p2,"Center");

setSize(300,250);

setBackground(Color.red);

}

public void actionPerformed(ActionEvent e){

flag=0;

try{query();}

catch(SQLException ee){}

}

public void query() throws SQLException{

String num,name,sex,subject,grade,born;

con=DriverManager.getConnection("jdbc:odbc:data","","");

ResultSet rs=sql.executeQuery("SELECT * FROM jesse ");

while(rs.next()){

num=rs.getString("学号");

name=rs.getString("姓名");

sex=rs.getString("性别");

subject=rs.getString("专业");

grade=rs.getString("年级");

born=rs.getString("出生");

if(num.equals(t1.getText().trim())){

t2.setText(name);

t3.setText(sex);

t4.setText(subject);

t5.setText(grade);

t6.setText(born);

flag=1;

break;

}

}

con.close();

if(flag==0){t1.setText("没有该学生");}

}

}

class Update extends Panel implements ActionListener{

Connection con;

Statement sql;

Button b1,b2,b3;

Box baseBox,bv1,bv2;

TextField t1,t2,t3,t4,t5,t6;

Update(){

try{

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

}

catch(ClassNotFoundException e){}

try{

con=DriverManager.getConnection("jdbc:odbc:data","","");

sql=con.createStatement();

}

catch(SQLException ee){}

setLayout(new BorderLayout());

b1=new Button("开始修改");

b1.setBackground(Color.green);

b2=new Button("录入修改");

b2.setBackground(Color.yellow);

b3=new Button("重置");

b3.setBackground(Color.yellow);

b1.addActionListener(this);

b2.addActionListener(this);

b3.addActionListener(this);

t1=new TextField(8);

t2=new TextField(16);

t3=new TextField(16);

t4=new TextField(16);

t5=new TextField(16);

t6=new TextField(16);

Panel p1=new Panel(),p2=new Panel(),p3=new Panel();

p1.add(new Label("输入要修改信息的学号"));

p1.add(t1);

p1.add(b1);

bv1=Box.createVerticalBox();

bv1.add(new Label("(新)姓名"));

bv1.add(Box.createVerticalStrut(8));

bv1.add(new Label("(新)性别"));

bv1.add(Box.createVerticalStrut(8));

bv1.add(new Label("(新)专业"));

bv1.add(Box.createVerticalStrut(8));

bv1.add(new Label("(新)年级"));

bv1.add(Box.createVerticalStrut(8));

bv1.add(new Label("(新)出生"));

bv1.add(Box.createVerticalStrut(8));

bv2=Box.createVerticalBox();

bv2.add(t2);

bv2.add(Box.createVerticalStrut(8));

bv2.add(t3);

bv2.add(Box.createVerticalStrut(8));

bv2.add(t4);

bv2.add(Box.createVerticalStrut(8));

bv2.add(t5);

bv2.add(Box.createVerticalStrut(8));

bv2.add(t6);

bv2.add(Box.createVerticalStrut(8));

baseBox=Box.createHorizontalBox();

baseBox.add(bv1);

baseBox.add(Box.createHorizontalStrut(10));

baseBox.add(bv2);

p2.add(baseBox);

p3.add(b2);

p3.add(b3);

add(p1,"North");

add(p2,"Center");

add(p3,"South");

setSize(300,250);

setBackground(Color.cyan);

}

public void actionPerformed(ActionEvent e){

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

try{

String num,name,sex,subject,grade,born;

con=DriverManager.getConnection("jdbc:odbc:data","","");

ResultSet rs=sql.executeQuery("SELECT * FROM jesse ");

while(rs.next()){

num=rs.getString("学号");

name=rs.getString("姓名");

sex=rs.getString("性别");

subject=rs.getString("专业");

grade=rs.getString("年级");

born=rs.getString("出生");

if(num.equals(t1.getText().trim())){

t2.setText(name);

t3.setText(sex);

t4.setText(subject);

t5.setText(grade);

t6.setText(born);

break;

}

}

con.close();

}

catch(SQLException ee){}

}

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

try{update();}

catch(SQLException ee){}

}

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

t2.setText(" ");

t3.setText(" ");

t4.setText(" ");

t5.setText(" ");

t6.setText(" ");

}

}

public void update() throws SQLException{

String s1="'"+t1.getText().trim()+"'";

String s2="'"+t2.getText().trim()+"'";

String s3="'"+t3.getText().trim()+"'";

String s4="'"+t4.getText().trim()+"'";

String s5="'"+t5.getText().trim()+"'";

String s6="'"+t6.getText().trim()+"'";

String temp="UPDATE jesse SET 姓名 ="+s2+", 性别="+s3+", 专业="+s4+", 年级="+s5+", 出生="+s6+" WHERE 学号="+s1;

con=DriverManager.getConnection("jdbc:odbc:data","","");

sql.executeQuery(temp);

con.close();

}

}

class Delete extends Panel implements ActionListener{

Connection con;

Statement sql;

TextField t1,t2,t3,t4,t5,t6;

Button b;

Box baseBox,bv1,bv2;

Delete(){

try{

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

}

catch(ClassNotFoundException e){}

try{

con=DriverManager.getConnection("jdbc:odbc:data","","");

sql=con.createStatement();

}

catch(SQLException ee){}

setLayout(new BorderLayout());

b=new Button("删除");

b.setBackground(Color.cyan);

b.addActionListener(this);

t1=new TextField(8);

t1.addActionListener(this);

t2=new TextField(16);

t3=new TextField(16);

t4=new TextField(16);

t5=new TextField(16);

t6=new TextField(16);

t2.setEditable(false);

t3.setEditable(false);

t4.setEditable(false);

t5.setEditable(false);

t6.setEditable(false);

Panel p1=new Panel(),p2=new Panel();

p1.add(new Label("输入要删除的学号"));

p1.add(t1);

p1.add(b);

bv1=Box.createVerticalBox();

bv1.add(new Label("姓名"));

bv1.add(Box.createVerticalStrut(8));

bv1.add(new Label("性别"));

bv1.add(Box.createVerticalStrut(8));

bv1.add(new Label("专业"));

bv1.add(Box.createVerticalStrut(8));

bv1.add(new Label("年级"));

bv1.add(Box.createVerticalStrut(8));

bv1.add(new Label("出生"));

bv1.add(Box.createVerticalStrut(8));

bv2=Box.createVerticalBox();

bv2.add(t2);

bv2.add(Box.createVerticalStrut(8));

bv2.add(t3);

bv2.add(Box.createVerticalStrut(8));

bv2.add(t4);

bv2.add(Box.createVerticalStrut(8));

bv2.add(t5);

bv2.add(Box.createVerticalStrut(8));

bv2.add(t6);

bv2.add(Box.createVerticalStrut(8));

baseBox=Box.createHorizontalBox();

baseBox.add(bv1);

baseBox.add(Box.createHorizontalStrut(10));

baseBox.add(bv2);

p2.add(baseBox);

add(p1,"North");

add(p2,"Center");

setSize(300,250);

setBackground(Color.green);

}

public void actionPerformed(ActionEvent e){

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

try{delete();}

catch(SQLException ee){}

}

else if(e.getSource()==b){

int n=JOptionPane.showConfirmDialog(this,"确定要删除该学号及全部信息吗?","确定",JOptionPane.YES_NO_OPTION);

if(n==JOptionPane.YES_OPTION){

try{

String s1="'"+t1.getText().trim()+"'";

String temp="DELETE FROM jesse WHERE 学号="+s1;

con=DriverManager.getConnection("jdbc:odbc:data","","");

sql.executeUpdate(temp);

con.close();

}

catch(SQLException ee){}

}

else if(n==JOptionPane.NO_OPTION){}

}

}

public void delete() throws SQLException{

String num,name,sex,subject,grade,born;

con=DriverManager.getConnection("jdbc:odbc:data","","");

ResultSet rs=sql.executeQuery("SELECT * FROM jesse ");

while(rs.next()){

num=rs.getString("学号");

name=rs.getString("姓名");

sex=rs.getString("性别");

subject=rs.getString("专业");

grade=rs.getString("年级");

born=rs.getString("出生");

if(num.equals(t1.getText().trim())){

t2.setText(name);

t3.setText(sex);

t4.setText(subject);

t5.setText(grade);

t6.setText(born);

break;

}

}

con.close();

}

}

public class tyj extends Frame implements ActionListener{

MenuBar bar=null;

Menu menu1,menu2,menu3,menu4,menu5;

MenuItem item1,item2,item3,item4,item5;

Add zengjia;

Query chaxun;

Update gengxin;

Delete shanchu;

tyj(){

super("欢迎进入学生信息管理系统");

zengjia=new Add();

chaxun=new Query();

gengxin=new Update();

shanchu=new Delete();

bar=new MenuBar();

menu1=new Menu("信息录入");

menu2=new Menu("信息查询");

menu3=new Menu("信息更新");

menu4=new Menu("信息删除");

menu5=new Menu("退出系统");

item1=new MenuItem("录入");

item2=new MenuItem("查询");

item3=new MenuItem("更新");

item4=new MenuItem("删除");

item5=new MenuItem("退出");

menu1.add(item1);

menu2.add(item2);

menu3.add(item3);

menu4.add(item4);

menu5.add(item5);

bar.add(menu1);

bar.add(menu2);

bar.add(menu3);

bar.add(menu4);

bar.add(menu5);

setMenuBar(bar);

item1.addActionListener(this);

item2.addActionListener(this);

item3.addActionListener(this);

item4.addActionListener(this);

item5.addActionListener(this);

Label label=new Label("欢迎进入学生信息管理系统",Label.CENTER);

String s=" ";

Font f=new Font(s,Font.BOLD,22);

label.setFont(f);

label.setBackground(Color.GREEN);

label.setForeground(Color.BLUE);

add(label,"Center");

setVisible(true);

setSize(320,300);

}

public void actionPerformed(ActionEvent e){

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

removeAll();

add(zengjia,"Center");

validate();

}

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

removeAll();

add(chaxun,"Center");

validate();

}

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

removeAll();

add(gengxin,"Center");

validate();

}

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

removeAll();

add(shanchu,"Center");

validate();

}

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

removeAll();

setBackground(Color.GREEN);

Label label=new Label("欢迎进入学生信息管理系统",Label.CENTER);

String s=" ";

Font f=new Font(s,Font.BOLD,22);

label.setFont(f);

label.setForeground(Color.BLUE);

add(label,"Center");

validate();

}

}

public static void main(String[] args)

{

tyj jesse=new tyj();

jesse.setVisible(true);

jesse.addWindowListener(new WindowAdapter(){

public void windowClosing(WindowEvent e){

System.exit(0);

}

});

}

}

Q4: 用java写的学生信息管理系统，能注册，查看和删除，要代码，各位大侠帮帮忙，

把你的邮箱给我，我发给你，我的邮箱是：kangkj@126.com QQ:229323989

学生注册查询代码java的介绍就聊到这里吧，感谢你花时间阅读本站内容，更多关于学生注册学号在哪查、学生注册查询代码java的信息别忘了在本站进行查找喔。