charc=s.charAt(i);
if(c<'0'||c>'9'){
Stringwarning="请输入数字!
";
JOptionPane.showMessageDialog(this,warning,"警告",JOptionPane.WARNING_MESSAGE);
办公电话.setText(null);
}
}
}
}
publicvoidactionPerformed(ActionEvente){
Stringname="";
Stringurl="jdbc:
odbc:
diaoyou1";
Strings1="";
Strings2="";
Strings3="";
Strings4="";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(java.lang.ClassNotFoundExceptioneee){}
s1=姓名.getText();
s2=手机号码.getText();
s3=家庭电话.getText();
s4=办公电话.getText();
Stringsql="insertintonumbervalues(?
?
?
?
)";
if(e.getSource()==确定){
if(s1==""){Stringwarning="必须输入姓名!
";
JOptionPane.showMessageDialog(this,warning,"警告",JOptionPane.WARNING_MESSAGE);
}
else{
Stringm="添加此人电话!
";
intok=JOptionPane.showConfirmDialog(this,m,"确认",JOptionPane.YES_NO_OPTION,
JOptionPane.INFORMATION_MESSAGE);
if(ok==JOptionPane.YES_OPTION){
try{
Connectioncon=DriverManager.getConnection(url,"",null);
Statementstmt=con.createStatement();
PreparedStatementps=con.prepareStatement(sql);
ps.setString(1,s1);
ps.setString(2,s2);
ps.setString(3,s3);
ps.setString(4,s4);
ps.executeUpdate();
stmt.close();
con.close();}catch(SQLExceptionex){System.out.println(ex.getMessage());}
}
}
姓名.setText(null);
手机号码.setText(null);
家庭电话.setText(null);
办公电话.setText(null);
}
if(e.getSource()==重置)
{
姓名.setText(null);
手机号码.setText(null);
家庭电话.setText(null);
办公电话.setText(null);
}
}
}
修改模块代码主要代码update.java
publicvoidactionPerformed(ActionEvente){
Stringname="";
Strings1="";
Strings2="";
Strings3="";
Strings4="";
Stringurl="jdbc:
odbc:
diaoyou1";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(java.lang.ClassNotFoundExceptioneee){}
if(e.getSource()==开始修改){
name=姓名.getText();
Stringsql="select*fromnumberwhere姓名='"+name+"'";
try{
Connectioncon=DriverManager.getConnection(url,"",null);
Statementstmt=con.createStatement();
ResultSetrs=stmt.executeQuery(sql);
while(rs.next()){
s1=rs.getString("姓名");
s2=rs.getString("手机号码");
s3=rs.getString("家庭电话");
s4=rs.getString("办公电话");
}
stmt.close();
con.close();
}catch(SQLExceptionex){System.out.println(ex.getMessage());}
if(s1!
=null){
录入修改.setEnabled(true);
手机号码.setText(s2);
家庭电话.setText(s3);
办公电话.setText(s4);
}
}
if(e.getSource()==录入修改){
name=姓名.getText();
s2=手机号码.getText();
s3=家庭电话.getText();
s4=办公电话.getText();
Stringsql2="updatenumberset手机号码='"+s2+"'"+"where姓名='"+name+"'";
Stringsql3="updatenumberset家庭电话='"+s3+"'"+"where姓名='"+name+"'";
Stringsql4="updatenumberset办公电话='"+s4+"'"+"where姓名='"+name+"'";
try{
Connectioncon=DriverManager.getConnection(url,"",null);
Statementstmt=con.createStatement();
stmt.executeUpdate(sql2);
stmt.executeUpdate(sql3);
stmt.executeUpdate(sql4);
stmt.close();
con.close();
}catch(SQLExceptionexx){System.out.println(exx.getMessage());}
}
if(e.getSource()==重置)
{
姓名.setText(null);
手机号码.setText(null);
家庭电话.setText(null);
办公电话.setText(null);
}
}
}
精确查询模块主要代码find.java
publicvoidactionPerformed(ActionEvente)
{
Stringname="";
Stringurl="jdbc:
odbc:
diaoyou1";
Strings1="";
Strings2="";
Strings3="";
Strings4="";
if(e.getSource()==查询)
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(java.lang.ClassNotFoundExceptioneee){}
name=姓名.getText();
Stringsql="select*fromnumberwhere姓名='"+name+"'";
if(name!
=""){
try{
Connectioncon=DriverManager.getConnection(url,"",null);
Statementstmt=con.createStatement();
ResultSetrs=stmt.executeQuery(sql);
while(rs.next()){
s1=rs.getString("姓名");
s2=rs.getString("手机号码");
s3=rs.getString("家庭电话");
s4=rs.getString("办公电话");
}
stmt.close();
con.close();
}catch(SQLExceptionex){System.out.println(ex.getMessage());}
if(s1!
=null){
姓名.setText(s1);
手机号码.setText(s2);
家庭电话.setText(s3);
办公电话.setText(s4);
}
}
}
if(e.getSource()==删除){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(java.lang.ClassNotFoundExceptioneee){}
name=姓名.getText();
Stringsql="deletefromnumberwhere姓名='"+name+"'";
try{
Connectioncon=DriverManager.getConnection(url,"",null);
Statementstmt=con.createStatement();
stmt.executeUpdate(sql);
stmt.close();
con.close();
}catch(SQLExceptioneex){System.out.println(eex.getMessage());}
姓名.setText(null);
手机号码.setText(null);
家庭电话.setText(null);
办公电话.setText(null);
}
}
}
整体查询模块完整代码ztcx.java
publicclassztcxextendsJPanelimplementsActionListener{
JTextArearuslt;
JButton查询;
Stringname;
Stringsql="";
JScrollPanescroll;
publicztcx(){
ruslt=newJTextArea(10,28);
ruslt.setEditable(false);
查询=newJButton("查询");
scroll=newJScrollPane(ruslt);
Boxbox2=Box.createHorizontalBox();
box2.add(查询);
Boxbox3=Box.createHorizontalBox();
box3.add(scroll);
BoxboxH=Box.createVerticalBox();
boxH.add(box2);
boxH.add(box3);
查询.addActionListener(this);
JPanelpCenter=newJPanel();
pCenter.add(boxH);
setLayout(newBorderLayout());
add(pCenter,BorderLayout.CENTER);
validate();
}
publicvoidactionPerformed(ActionEvente){
Stringurl="jdbc:
odbc:
diaoyou1";
Strings1="";
Strings2="";
Strings3="";
Strings4="";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(java.lang.ClassNotFoundExceptioneee){}
if(e.getSource()==查询){
try{
Connectioncon=DriverManager.getConnection(url,"",null);
Statementstmt=con.createStatement();
sql="select*fromnumber";
ResultSetrs=stmt.executeQuery(sql);
ruslt.setText("姓名手机号码家庭电话办公电话\n");
if(!
rs.next())
ruslt.setText("无记录");
else
{
do{
s1=rs.getString("姓名");
s2=rs.getString("手机号码");
s3=rs.getString("家庭电话");
s4=rs.getString("办公电话");
ruslt.append(s1);
ruslt.append(s2);
ruslt.append(s3);
ruslt.append(s4+"\n");
}while(rs.next());
}
stmt.close();
con.close();
}catch(SQLExceptionex){System.out.println(ex.getMessage());}
}
}
}
模糊查询模块完整代码mhcx.java
publicclassmhcxextendsJPanelimplementsActionListener{
JTextArearuslt;
JTextFieldtj;
JButton查询;
Stringname;
Stringsql="";
JLa