java学生信息录入和查询(连接mysql数据库)

1.成绩录入

package studentManage;

import java.awt.GridLayout;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import javax.swing.*;

public class StudentManageSystem extends JFrame{

JTextField jtfdID = new JTextField(8);

JTextField jtfdName = new JTextField(128);

JTextField jtfdSex = new JTextField(128);

JTextField jtfdAge = new JTextField(8);

public StudentManageSystem(){

JButton jbtnEnter= new JButton("录入");

JButton jbtnClear= new JButton("清零");

JLabel jlblID = new JLabel("学号");

JLabel jlblName = new JLabel("姓名");

JLabel jlblSex = new JLabel("性别");

JLabel jlblAge = new JLabel("年龄");

setLayout(new GridLayout(5,2,5,5));

add(jlblID);

add(jtfdID);

add(jlblName);

add(jtfdName);

add(jlblSex);

add(jtfdSex);

add(jlblAge);

add(jtfdAge);

add(jbtnEnter);

add(jbtnClear);

jbtnEnter.addActionListener(new EnterListener());

jbtnClear.addActionListener(new ClearListener());

}

class EnterListener implements ActionListener{

public void actionPerformed(ActionEvent e){

Boolean rs = null;

try{

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

Connection conn =

DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test?useUnicode=true& characterEncoding=utf8","root1","root");

Statement stmt = conn.createStatement();

String sql = "insert into student

values('"+jtfdID.getText()+"','"+jtfdName.getText()+"','"+jtfdSex.getText()+"' ,'"+jtfdAge.getText()+"')";

stmt.execute(sql);

jtfdID.setText(" ");

jtfdName.setText(" ");

jtfdSex.setText(" ");

jtfdAge.setText(" ");

}

catch (ClassNotFoundException e2) {

System.out.println("Sorry,can't find the Driver!");

e2.printStackTrace();

} catch (SQLException e3) {

e3.printStackTrace();

} catch (Exception e4) {

e4.printStackTrace();

}

}

}

class ClearListener implements ActionListener{

public void actionPerformed(ActionEvent e){

jtfdID.setText("");

jtfdName.setText("");

jtfdSex.setText("");

jtfdAge.setText("");

}

}

public static void main (String[] args){

StudentManageSystem s = new StudentManageSystem();

s.setTitle("学生个人信息录入");

s.setSize(400,300);

s.setLocationRelativeTo(null);

s.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

s.setVisible(true);

}

}

2.成绩查询

import java.awt.BorderLayout;

import java.awt.FlowLayout;

import java.awt.GridLayout;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import javax.swing.JButton;

import javax.swing.JComboBox;

import javax.swing.JFrame;

import javax.swing.JPanel;

import javax.swing.JTextField;

import com.mysql.jdbc.PreparedStatement;

public class Search extends JFrame{

JComboBox jcbSelect= new JComboBox();

JTextField jtfdInput = new JTextField();

JButton jbtnSearch = new JButton("查询");

String slt = null;//确定下拉框所选的内容

public Search(){

jcbSelect.addItem("学号");

jcbSelect.addItem("姓名");

jcbSelect.addItem("性别");

jcbSelect.addItem("年龄");

JPanel jpl1=new JPanel(new GridLayout(2,1));

//setLayout(new GridLayout(2,1));

jpl1.add(jcbSelect);

jpl1.add(jtfdInput);

setLayout(new GridLayout(2,1));

add(jpl1);

add(jbtnSearch);

jbtnSearch.addActionListener(new SearchListener());

if(jcbSelect.getSelectedItem()=="学号"){

slt="Sno";

}

else if(jcbSelect.getSelectedItem()=="姓名"){

slt = "Sname";

}

else if(jcbSelect.getSelectedItem()=="性别"){

slt = "Ssex";

}

else{

slt = "Sage";

}

}

class SearchListener implements ActionListener{

public void actionPerformed(ActionEvent e){

ResultSet rs = null;

try{

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

Connection conn =

DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test","root1","root") ;

//PreparedStatement ps = conn.prepareStatement("select * from student where "+slt+"like '%?%'");

Statement stmt = conn.createStatement();

String sql= "select * from student where "+slt+"="+ jtfdInput.getText();

rs = stmt.executeQuery(sql);

}

catch (ClassNotFoundException e2) {

System.out.println("Sorry,can't find the Driver!");

e2.printStackTrace();

} catch (SQLException e3) {

e3.printStackTrace();

} catch (Exception e4) {

e4.printStackTrace();

}

{

try {

while(rs.next())

{

System.out.println(rs.getString(1)+"\t"+rs.getString(2)+"\t"+rs.getString( 3)+"\t"+rs.getInt(4));

}

} catch (SQLException e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}//while循环输出结果

}

}

}

public static void main (String[] args){

Search s = new Search();

s.setTitle("学生个人信息查询");

s.setSize(300,200);

s.setLocationRelativeTo(null);

s.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

s.setVisible(true);

}

}