當前位置:編程學習大全網 - 源碼下載 - 數據查詢顯示系統源代碼

數據查詢顯示系統源代碼

導入Java . awt . borderlayout;

導入Java . awt . card layout;

導入Java . awt . container;

導入Java . awt . font;

導入Java . awt . event . action event;

導入Java . awt . event . action listener;

導入javax . swing . icon;

導入javax . swing . image icon;

導入javax . swing . jbutton;

導入javax . swing . jframe;

導入javax . swing . jlabel;

導入javax . swing . jmenu;

導入javax . swing . jmenubar;

導入javax . swing . jmenuitem;

導入javax . swing . jpanel;

導入javax . swing . jtoolbar;

導入javax . swing . swing constants;

公共類MainFrame擴展JFrame實現ActionListener{

InsertPanel ip = null

SelectPanel sp = null

JPanel pframe

JButton jb1,jb2,jb3

JMenuItem jm11,jm21,jm22,jm23,jm31,jm32,jm41,jm42

CardLayout clayout

公共大型機(字符串){

超級用戶;

JMenuBar MB = new JMenuBar();

this . setjmenubar(MB);

JMenu m 1 = new JMenu(" system ");

JMenu m2 = new JMenu("基本信息");

JMenu m3 =新JMenu(" grade ");

JMenu m4 = new JMenu("獎懲");

MB . add(m 1);

MB . add(m2);

MB . add(m3);

MB . add(M4);

Jm11 = new JMenuItem("退出系統");

JM 21 = new JMenuItem(" input ");

jm22 = new JMenuItem(" query ");

jm23 = new JMenuItem(" change ");

Jm31 = new JMenuItem("輸入等級");

Jm32 = new JMenuItem("查詢結果");

JM 41 = new JMenuItem(" reward ");

Jm42 = new JMenuItem("懲罰");

m 1 . add(JM 11);

m2 . add(JM 21);

m2 . add(jm22);

m2 . add(jm23);

m3 . add(JM 31);

m3 . add(jm32);

M4 . add(JM 41);

M4 . add(jm42);

icon I 1 = new image icon();

icon I2 = new image icon();

icon i3 = new image icon();

JB 1 = new JButton(I 1);

JB 1 . settooltiptext(" input ");

jb2 = new JButton(I2);

jb2 . settooltiptext(" query ");

jb3 = new JButton(i3);

jb3 . settooltiptext(" exit ");

JToolBar tb = new JToolBar("系統工具");

TB . add(JB 1);

TB . add(jb2);

TB . add(jb3);

添加(tb,BorderLayout。北);

JM 11 . addactionlistener(this);

JM 21 . addactionlistener(this);

jm22 . addactionlistener(this);

JB 1 . addactionlistener(this);

jb2 . addactionlistener(this);

jb3 . addactionlistener(this);

clayout = new card layout();

pframe = new JPanel(clayout);

添加(p frame);

JPanel mainp = new JPanel(new BorderLayout());

JLabel mainl = new JLabel(“學生信息管理平臺”,SwingConstants。中心);

mainl.setFont(新字體(" serif ",字體。粗體,30));

mainp . add(mainl);

pframe.add(mainp," main ");

clayout.show(pframe," main ");

}

public void action performed(action event e){

if(e . getsource()= = JM 21 | | e . getsource()= = JB 1){

if(ip == null){

IP = new insert panel();

pframe.add(ip," insert ");

}

clayout.show(pframe," insert ");

This.setTitle("輸入學生信息");

}

else if(e . getsource()= = jm22 | | e . getsource()= = jb2){

if(sp == null){

sp = new select panel();

pframe.add(sp," select ");

}

clayout.show(pframe," select ");

This.setTitle("查詢學生信息");

}

else if(e . getsource()= = JM 11 | | e . getsource()= = jb3){

system . exit(0);

}

}

}

第二個:

導入javax . swing . jframe;

公共類主測試{

公共靜態void main(String [] args){

大型機f =新大型機(“學生信息管理平臺”);

f.setSize(400,300);

f.setLocation(350,250);

f . setdefaultcloseoperation(JFrame。EXIT _ ON _ CLOSE);

f . set visible(true);

}

}

第二個:

導入Java . SQL . connection;

導入Java . SQL . driver manager;

公共類MySQLConnection {

靜態連接getCon(){

Connection con = null

嘗試{

class . forname(" com . MySQL . JDBC . driver ");

con = driver manager . getconnection(" JDBC:MySQL://localhost/test "," root "," 123 ");

}

捕捉(異常e){

System.out.println("建立數據庫連接異常!");

}

返回con

}

}

第四個:

導入Java . awt . borderlayout;

導入Java . awt . gridlayout;

導入Java . awt . event . action event;

導入Java . awt . event . action listener;

導入javax . swing . jbutton;

導入javax . swing . jlabel;

導入javax . swing . joptionpane;

導入javax . swing . jpanel;

導入javax . swing . jtextfield;

導入javax . swing . swing constants;

公共類SelectPanel擴展JPanel實現ActionListener{

JButton jb

JTextField jt

JTextField jt1,jt2,jt3,jt4

公共選擇面板(){

JLabel jl = new JLabel("請輸入您的學號:",SwingConstants。中心);

JT = new JTextField();

JB = new JButton(" ok ");

JPanel jp 1 = new JPanel(new GridLayout(1,3));

jp 1 . add(JL);

jp 1 . add(JT);

jp 1 . add(JB);

JLabel j1,j2,j3,j4;

J1 = new JLabel("學生ID:",SwingConstants。中心);

J2 =新JLabel ("Name:",SwingConstants。中心);

JBOY3樂隊= new JLabel ("Gender:",SwingConstants。中心);

J4 =新JLabel("年齡:",搖擺常數。中心);

JT 1 = new JTextField(6);

JT 1 . set editable(false);

jt2 = new JTextField(6);

jt2 . set editable(false);

jt3 = new JTextField(6);

jt3 . set editable(false);

jt4 = new JTextField(6);

jt4 . set editable(false);

JPanel jp2 = new JPanel(new BorderLayout());

JPanel jp3 = new JPanel(new GridLayout(4,2));

jp2.add(new JLabel(" "),BorderLayout。北);

jp3 . add(j 1);

jp3 . add(JT 1);

jp3 . add(J2);

jp3 . add(jt2);

jp3 . add(J3);

jp3 . add(jt3);

jp3 . add(j4);

jp3 . add(jt4);

jp2 . add(jp3);

this . set layout(new BorderLayout());

add(jp1,BorderLayout。北);

添加(jp2);

JB . addactionlistener(this);

}

public void action performed(action event e){

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

String stuNo = jt.getText()。trim();

學生s =新生();

布爾b =真;

嘗試{

b = s . selectbystuno(stuNo);

}

catch(例外){

System.out.println("查詢學生信息異常!");

}

如果(b){

JT 1 . settext(s . getstuno());

jt2 . settext(s . getname());

jt3 . settext(s . getgender());

int a = s . getage();

整數i =新整數(a);

jt4 . settext(I . tostring());

}

否則{

Joption窗格。顯示消息對話框(空,“沒有這樣的學生!”);

}

}

}

}

第五個:

導入javax . swing . jframe;

公共類選擇測試{

公共靜態void main(String [] args){

JFrame f = new JFrame("查詢學生信息");

select panel p = new select panel();

f .添加(p);

f.setSize(400,300);

f.setLocation(300,250);

f . setdefaultcloseoperation(JFrame。EXIT _ ON _ CLOSE);

f . set visible(true);

}

}

第六個:

導入Java . SQL . connection;

導入Java . SQL . resultset;

導入Java . SQL . statement;

公共課學生{

弦樂斯圖諾;

字符串名稱;

字符串性別;

int age

公共學生(){}

公共學生(字符串stuNo,字符串name,字符串gender,int age){

this.stuNo = stuNo

this.name = name

this.gender =性別;

this.age =年齡;

}

公共字符串getStuNo(){

返回stuNo

}

public void setStuNo(String stuNo){

this.stuNo = stuNo

}

公共字符串getName(){

返回名稱;

}

public void setName(字符串名){

this.name = name

}

公共字符串getGender(){

返回性別;

}

public void set gender(String gender){

this.gender =性別;

}

public int getAge(){

回歸年齡;

}

公共無效存儲(整數){

this.age =年齡;

}

public boolean insertStudent(){

布爾b =真;

嘗試{

connection con = MySQL connection . getcon();

Statement語句= con . create statement();

string SQL = " insert into student values("+stuNo+" ',' "+ name +" ',' "+ gender +" ',"+age+")";

SQL = new String(SQL . getbytes(" GB 2312 ")," ISO8859 _ 1 ");

語句. execute update(SQL);

con . close();

}

捕捉(異常e){

b =假;

System.out.println("插入數據庫時出現異常!");

}

返回b;

}

public boolean selectByStuNo(String stuNo)拋出異常{

布爾b =真;

connection con = MySQL connection . getcon();

Statement語句= con . create statement();

string SQL = " select * from student where stuNo = "+stuNo;

ResultSet RS = statement . execute query(SQL);

如果(rs!= null & amp& amprs.next()){

string no = RS . getstring(1);

this.setStuNo(否);

string n = RS . getstring(2);

n =新字符串(n.getBytes("ISO8859_1 ")," GB 2312 ");

this . setname(n);

string g = RS . getstring(3);

g =新字符串(g.getBytes("ISO8859_1 ")," GB 2312 ");

this . set gender(g);

this . setage(RS . getint(4));

b =真;

}

RS . close();

statement . close();

con . close();

返回b;

}

}

自己做數據庫,我沒時間做!初學者需要做更多的工作。

  • 上一篇:新手炒股怎麽玩短線股票?
  • 下一篇:不可預料的壓縮文件末端 ,加密文件 CRC 失敗(密碼錯誤嗎?)請幫我解決這兩個問題
  • copyright 2024編程學習大全網