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

1、1 .成绩录入 package stude ntma nage;import import import import import import import import import javax.swing.*;public class studcntmanaqesystem extends jframejtextfield jtfdld = newjtextfield(8);jtextfield jtfdname = newjtextfield(128);jtextfield jtfdsex = newjtextfield(128);jtextfield jtfdage = newjt

2、extfield(8);public studentmanagesystem()jbutton jbtnenter = new jbutton(录入”)；jbutton jbtnclear = new j button (n 清零”);jlabel jlblld = new jlabel( “学号”)；jlabel jlblname = new jlabel( 姓名”);jlabel jlblsex = newjlabel(m 性别)jlabel jlblage = newjlabel(年龄”);setlayout( newgridlayout(5,2,5,5);add(jlblld );ad

3、d(jtfdld );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 actionlistenerpublic void acti on perform

4、ed(act ion eve nt e)boolean rs = null ;tryclass. forname();connection conn = drivermanager. getconnection (, nroot1n, root);statement stmt = conn.createstatement();string sql = insert into studentvalues。 +jtfdld .gettext()+ +jtfdname .gettext()+ 7 +jtfdsex .gettext()+ 二”+jtfdage .gettext()+ ;stmt .e

5、xecute( sql);jtfdid .settext(h 1);jtfdname .settext(jtfdsex .settext( * !);jtfdage .settext(catch (classnotfoundexception e2) system, out .println( sorry,cant find the driver!1);e2.printstackt race(); catch (sqlexception e3) e3.printstackt race(); catch (exception e4) e4.printstacktrace();class clea

6、rlistener implements actionlistenerpublic void actionperformed(actionevent e)jtfdld .settext(,h,);jtfdname .settext( );jtfdsex .settext();jtfdage .settext(); )public static void main (stringargs )studentmanagesystem s = new studentmanagesystem();s.settitle (学生个人信息录入”);s.setsize(400,300);s.setlocatio

7、nrelativeto( null);s.setdefaultcloseoperation(jframe. exit_on_clos);es.setvisible( true );)2.成绩查询import;import;importimportimportimportimport importimport importimport importimport import import import;public class search extends jframejcomboboxjcbselect = n ewjcomboboxq;jtextfield jtfd in put = new

8、jtextfield();jbutton jbtnsearch = newjbuttonc查询”);string sit = null ; 确定下拉框所选的内容 public search()jcbselect .addltem(“学号”上 jcbselect .cddltem(“姓名”);jcbselect .adchtem。性另);jcbseiect ,addltem(“年首令”上jpanel jpll =new jpanel( newgridlayout(2,1);/setlayout(new gridlayout(251);jpll .add( jcbselect);jpl1 .add

9、( jtfdlnput);setlayout( newgridlayout(2,1);add(jph );add(jbtnsearch );jbtnsearch .addactionlistener( new searchlistener();if (jcbselect .getselectedltem()=学号”)sit =s no”； else if (jcbselect .getselectedltem()=姓名)sit hsnameh;else if (jcbselect .getselectedltem()= 性别) sit = ssex” ;)else sit = sage;cla

10、ss searchlistener implements actionlistenerpublic void actionperformed(actionevent e) resultset rs = null ;tryclass. forname();connection conn = drivermanager. getconnection (, rootlroot);/preparedstateme nt ps = conn .preparestateme nt(select * from student where ”+slt+”like ,%?%h,);state me ntstmt

11、 = conn. createstateme nt();string sql = select * from stude nt where ” +slt +”= + jtfdl nput.gettext();rs = stmt .executequery( sql);catch (classnotfoundexception e2) system.out .println( sorry,cant find the driver!11);e2.pri ntstacktrace(); catch (sqlexception e3) e3.pri ntstacktrace(); catch (exception e4) e4.pri ntstacktrace();trywhile (rs .next()system, out .println( rs .getstring(1)+ th +rs .getstring(2)+ ”t +rs .getstring(3)+ at +rs .getlnt(4); catch (sqlexception e1) / todoauto-generated catch blocke1 .printstacktrace();/while循环输出结果public static void