導入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;
}
}
自己做數據庫,我沒時間做!初學者需要做更多的工作。