java查询信息代码下载 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);

}

第二个：

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;

}

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

相关问答

Q1: 按用户ID查询用户信息的java编程代码用户id：1003 用户名：sandy 年龄：15 地址：广州电话：131111111

//jdbc？下面是java通过jdbc从数据库查询表格，返回ResultSet 对象的代码

String sql = "select username,password from account";

String user = request.getParameter("user");

String pass = request.getParameter("password");

int j = 0;

Connection conn = null;

PreparedStatement ps = null;

ResultSet rs = null;

try {

conn = JDBCTools1.getConnection();

ps = conn.prepareStatement(sql);

rs = ps.executeQuery();

//ResultSet 对象可以使用rs.getString(序列号从一开始);的方法获得查询结果并显示出来

Q2: java代码怎样将oracle数据库中数据下载本地，为.txt文件或者.excel文件。

第一个类：

package totabel.action;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import javax.swing.JOptionPane;

import topdf.TableToPdf;

import totabel.view.TabelData;

import totabel.xls.ExcelDemo;

public class TableAction implements ActionListener {

TabelData data;

public TableAction(TabelData data) {

this.data = data;

}

public void actionPerformed(ActionEvent e) {

String str = e.getActionCommand();

if ("添加".equals(str)) {

data.addData();

} else if ("导出到Excel".equals(str)) {

ExcelDemo demo = new ExcelDemo();

demo.method(data);

} else if ("删除".equals(str)) {

if (data.getRow() != -1) {

data.delRow();

} else {

JOptionPane.showMessageDialog(null, "请选择要删除的行！");

}

}else if("从Excel导入".equals(str)){

data.getXlsInfo();

}else if("从Excel导入到数据库".equals(str)){

data.toDb();

}else if("从table导出到pdf".equals(str)){

TableToPdf pdf=new TableToPdf();

pdf.newPage(data);

}else if("计算学分".equals(str)){

data.getXlsInfoToCredit();

}

第二个类：数据库连接

package totabel.db;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class JdbcConnection {

private static JdbcConnection con;

public static JdbcConnection getCon() {

if (con == null) {

con = new JdbcConnection();

}

return con;

}

public Connection getConnection() {

Connection connection=null;

try {

Class.forName("oracle.jdbc.OracleDriver");

String url = "jdbc:oracle:thin:@127.0.0.1:1521:oracle";

String user = "scott";

String password = "tiger";

connection = DriverManager.getConnection(url, user,

password);

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

}

return connection;

}

// public static void main(String[] args) {

// JdbcConnection connection=new JdbcConnection();

// connection.getConnection("asd", "99");

// }

}

第三个类：主类（入口）

package totabel.db;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class JdbcConnection {

private static JdbcConnection con;

public static JdbcConnection getCon() {

if (con == null) {

con = new JdbcConnection();

}

return con;

}

public Connection getConnection() {

Connection connection=null;

try {

Class.forName("oracle.jdbc.OracleDriver");

String url = "jdbc:oracle:thin:@127.0.0.1:1521:oracle";

String user = "scott";

String password = "tiger";

connection = DriverManager.getConnection(url, user,

password);

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

}

return connection;

}

// public static void main(String[] args) {

// JdbcConnection connection=new JdbcConnection();

// connection.getConnection("asd", "99");

// }

}

第四个类：

package totabel.xls;

import java.io.File;

import java.io.IOException;

import java.util.Vector;

import java.util.regex.Matcher;

import java.util.regex.Pattern;

import javax.swing.JOptionPane;

import totabel.view.TabelData;

import jxl.Cell;

import jxl.Sheet;

import jxl.Workbook;

import jxl.read.biff.BiffException;

import jxl.write.Label;

import jxl.write.WritableSheet;

import jxl.write.WritableWorkbook;

import jxl.write.WriteException;

import jxl.write.biff.RowsExceededException;

public class ExcelDemo {

/**

* @param args

private Vector title = new Vector();

private Vector[] array;

// public static void main(String[] args) {

// ExcelDemo demo = new ExcelDemo();

// demo.getXlsInfo();

// }

public void method(TabelData table) {

int row = table.getRowSize();

int column = table.getColumnSize();

WritableWorkbook book = null;

Vector title = table.setTitle();

Object[] str = title.toArray();

try {

book = Workbook.createWorkbook(new File("test.xls"));

WritableSheet sheet = book.createSheet("成绩表", 0);

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

sheet.addCell(new Label(i, 0, (String) str[i]));

}

for (int i = 1; i row + 1; i++) {

for (int j = 1; j column + 1; j++) {

sheet.addCell(new Label(j - 1, i, table.getTableInfo(i - 1,

j - 1)));

}

book.write();

JOptionPane.showMessageDialog(null, "导出完成！");

} catch (IOException e) {

e.printStackTrace();

} catch (RowsExceededException e) {

e.printStackTrace();

} catch (WriteException e) {

e.printStackTrace();

} finally {

try {

book.close();

} catch (WriteException e) {

e.printStackTrace();

} catch (IOException e) {

e.printStackTrace();

}

/**

* 输出Excel的数据到表单

* @return

public Vector getXlsInfo() {

Vector v = new Vector();

jxl.Workbook rwb = null;

int index = 0;

try {

rwb = jxl.Workbook.getWorkbook(new File("test.xls"));

Sheet[] sheet = rwb.getSheets();

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

int rs = sheet[i].getRows();

array = new Vector[rs - 1];

for (int j = 1; j rs; j++) {

Cell[] cell = sheet[i].getRow(j);

Vector info = new Vector();

for (int k = 0; k cell.length; k++) {

info.add(cell[k].getContents());

}

array[index] = info;

index++;

v.add(info);

}

Cell[] titleCell = sheet[i].getRow(0);

for (int j = 0; j titleCell.length; j++) {

title.add(titleCell[j].getContents());

}

} catch (BiffException e) {

e.printStackTrace();

} catch (IOException e) {

e.printStackTrace();

} finally {

rwb.close();

}

return v;

}

public Vector getXlsInfoToCredit() {

Vector v = new Vector();

jxl.Workbook rwb = null;

try {

rwb = jxl.Workbook.getWorkbook(new File("d:/test/信科0821（南迁）.xls"));

Sheet[] sheet = rwb.getSheets();

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

int rs = sheet[i].getRows();

array = new Vector[rs - 1];

for (int j = 1; j rs; j++) {

Cell[] cell = sheet[i].getRow(j);

Vector info = new Vector();

for (int k = 0; k cell.length; k++) {

// if(){

Pattern p = Pattern.compile("[0-9]{1,}");

Matcher m = p.matcher(cell[k].getContents());

if (m.matches()) {

int score = Integer.valueOf(cell[k].getContents());

float result = getScore(score);

info.add(result);

} else {

info.add(cell[k].getContents());

}

v.add(info);

}

Cell[] titleCell = sheet[i].getRow(0);

for (int j = 0; j titleCell.length; j++) {

title.add(titleCell[j].getContents());

}

} catch (BiffException e) {

e.printStackTrace();

} catch (IOException e) {

e.printStackTrace();

} finally {

rwb.close();

}

return v;

}

public float getScore(int n) {

float score = n;

if (n 60) {

score = 0;

return score;

} else {

if (n = 60 n = 63) {

score = (float) 1.0;

} else if (n = 64 n = 67) {

score = (float) 1.3;

} else if (n = 68 n = 71) {

score = (float) 1.7;

} else if (n = 72 n = 75) {

score = (float) 2.0;

} else if (n = 76 n = 79) {

score = (float) 2.3;

} else if (n = 80 n = 83) {

score = (float) 2.7;

} else if (n = 84 n = 87) {

score = (float) 3.0;

} else if (n = 88 n = 91) {

score = (float) 3.3;

} else if (n = 92 n = 95) {

score = (float) 3.7;

} else if (n = 96 n = 100) {

score = (float) 4.0;

}

return score;

}

public Vector getTitle() {

// getXlsInfo();

return title;

}

public Vector[] getArray() {

getXlsInfo();

return array;

}

因为时间问题就没有再写了，上面是我以前做的，不懂就q我

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

正文

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

相关问答

相关阅读

头歌java面向对象，头歌JAVA面向对象String类

map以string存到redis，map string

string面向对象教程，java面向对象string类

redis怎么存String，Redis怎么存分时数据

js中object转换为数组中，js将object转换成string

go语言stmt，go语言string类型

JS中Date与String的相互转换，js date转字符串

pg数据库字符串类型变量，数据库字符串string

目录[+]