swingmysqljava
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;
class test
{
/*private string driver=com.mysql.jdbc.driver;
private string url=jdbc:mysql://localhost:3306/technology;
private string user=root;
private string pass=root;*/
jframe f;dialog d1,d2,r_interface;jbutton jb1,jb2,b3,b4,b5,r_inquire,r_insert,r_delete;jlabel jl,l1,l2;textfield tf1;textfield tf2;test(){ init();}public void init(){ /*try { class.forname(driver); } catch (classnotfoundexception e1) { // todo auto-generated catch block e1.printstacktrace(); }*/ f=new jframe(); jl=new jlabel(江西农业大学三检工作系统); jb1=new jbutton(登陆); jb2=new jbutton(注册); f.setvisible(true); f.setbounds(400,200,400,300); f.setlayout(null); f.setresizable(false); jb1.setbounds(110,130,70,30); jb2.setbounds(200,130,70,30); jl.setbounds(110,70,200,50); f.add(jb1); f.add(jb2); f.add(jl); d1=new dialog(f,用户登陆,true); d2=new dialog(f,用户注册,true); b3=new jbutton(确定); b4=new jbutton(取消); //登陆界面的取消按钮 b5=new jbutton(取消); //注册界面的取消按钮 myevent();}public void myevent(){ f.addwindowlistener(new windowadapter() //窗口退出事件监听 { public void windowclosing(windowevent e) { system.exit(0); } }); d1.addwindowlistener(new windowadapter() { public void windowclosing(windowevent e) { d1.setvisible(false); } }); d2.addwindowlistener(new windowadapter() { public void windowclosing(windowevent e) { d2.setvisible(false); } }); b3.addactionlistener(new actionlistener() //登陆界面的确定 { public void actionperformed(actionevent e) { dlcg(); } }); b4.addactionlistener(new actionlistener() { public void actionperformed(actionevent e) { d1.setvisible(false); } }); b5.addactionlistener(new actionlistener() { public void actionperformed(actionevent e) { d2.setvisible(false); } }); jb1.addactionlistener(new actionlistener() { public void actionperformed(actionevent e) { denglu(); } }); jb2.addactionlistener(new actionlistener() { public void actionperformed(actionevent e) { zhuce(); } });}public void dlcg(){ r_interface=new dialog(f,登陆成功,true); r_inquire=new jbutton(查询); r_insert=new jbutton(插入); r_delete=new jbutton(删除); r_interface.setlayout(null); r_interface.add(r_inquire); r_inquire.setbounds(80,60,120,30); r_interface.setvisible(true); connection conn = null; preparedstatement psta=null; string z_user=string.valueof(tf1.gettext()); string z_pass=string.valueof(tf2.gettext()); try { class.forname(com.mysql.jdbc.driver); conn = drivermanager.getconnection(jdbc:mysql://localhost:3306/mydb,root,root); psta = conn.preparestatement(insert into teacher (tname,tage) values (?, ?)); psta.setstring(1,z_user); psta.setstring(2,z_pass); psta.executeupdate(); } catch(classnotfoundexception e) { e.printstacktrace(); } catch(sqlexception e) { e.printstacktrace(); } finally { try { if(conn != null) { conn.close(); } if(psta != null) { psta.close(); } } catch(sqlexception e) { e.printstacktrace(); } } /*string z_user=tf1.gettext(); string z_pass=tf2.gettext(); connection cn = null; preparedstatement pst = null; try { string sql=insert into register (r_account,r_password) values (?, ?); cn = drivermanager.getconnection(url,user,pass); pst = cn.preparestatement(sql); pst.setstring(1,z_user); pst.setstring(2,z_pass); pst.executeupdate(); } catch(sqlexception e) { e.printstacktrace(); } finally { try { if(pst!=null) { pst.close(); } if(cn!=null) { cn.close(); } } catch(sqlexception e) { e.printstacktrace(); } } */}public void denglu(){ l1=new jlabel(用户名); l2=new jlabel(密 码); tf1=new textfield(); tf2=new textfield(); tf2.setechochar('*'); d1.setbounds(470,240,260,230); d1.setlayout(null); d1.setresizable(false); d1.add(l1); d1.add(l2); d1.add(b3); d1.add(b4); d1.add(tf1); d1.add(tf2); tf1.setbounds(80,60,120,30); tf2.setbounds(80,100,120,30); tf1.setfont(new font(宋体,1,20)); tf2.setfont(new font(宋体,1,20)); b3.setbounds(50,150,70,30); b4.setbounds(150,150,70,30); l1.setbounds(20,60,50,30); l2.setbounds(20,100,50,30); d1.setvisible(true); }public void zhuce(){ l1=new jlabel(注册名); l2=new jlabel(密 码); //b3=new jbutton(确定); tf1=new textfield(); tf2=new textfield(); tf2.setechochar('*'); d2.setbounds(470,240,260,230); d2.setlayout(null); d2.setresizable(false); d2.add(l1); d2.add(l2); d2.add(b3); d2.add(b5); d2.add(tf1); d2.add(tf2); tf1.setbounds(80,60,120,30); tf2.setbounds(80,100,120,30); tf1.setfont(new font(宋体,1,20)); tf2.setfont(new font(宋体,1,20)); b3.setbounds(50,150,70,30); b5.setbounds(150,150,70,30); l1.setbounds(20,60,50,30); l2.setbounds(20,100,50,30); d2.setvisible(true);}public static void main(string[] args){ connection conn = null; preparedstatement psta=null; new test(); }
}