为什么我做的JAVA程序可以和数据连接但连接后写入表中的数据相当于没写是怎么回事？

jojeylin 2008-03-13 01:27:41

为什么我做的JAVA程序可以和数据连接但连接后写入表中的数据相当于没写是怎么回事？源码如下:
import java.awt.FlowLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.ArrayList;
import java.util.List;
import java.util.Vector;
import java.net.URL;

import javax.swing.JFrame;
import javax.swing.JList;
import javax.swing.JMenu;
import javax.swing.JMenuBar;
import javax.swing.JMenuItem;
import javax.swing.SwingConstants;
import javax.swing.JDialog;
import java.io.*;
import java.sql.*;

import javax.swing.JButton;
import javax.swing.JTextField;
import javax.swing.JTable;
import javax.swing.JLabel;
import javax.swing.JComboBox;
import javax.swing.JPanel;

class User_info extends JDialog{
JLabel username=new JLabel("病人姓名:");
JLabel usersex=new JLabel("病人性别:");
JLabel userstatus=new JLabel("婚姻状态:");
JLabel usertel=new JLabel("电话:");
JLabel userfamily=new JLabel("家庭信息:");
JLabel roomnumber=new JLabel("所住房号:");
JLabel userbirth=new JLabel("出生日期:");
JLabel userjob=new JLabel("职务:");

JTextField txtusername=new JTextField(4);
String[] tsex=new String[]{"男","女"};
String[] userstatues=new String[]{"未婚","已婚","离异"};
JTextField txtusertel=new JTextField(13);
JTextField txtuserfamily=new JTextField(20);
JTextField txtroomnumber=new JTextField(20);
JTextField txtuserbirth=new JTextField(20);
JTextField txtuserjob=new JTextField(10);
JComboBox csex=new JComboBox(tsex);
JComboBox cstatus=new JComboBox(userstatues);
JButton button_ok=new JButton("确定");
JButton button_cancel=new JButton("取消");
JButton button_modify=new JButton("修改");
//csex.addActionListener(new ActionListener(){});
//cstatus.addActionListener(new ActionListener(){});

FlowLayout flowlayout2=new FlowLayout(SwingConstants.CENTER);
JPanel jpanel1=new JPanel();
public User_info()
{
jpanel1=(JPanel)this.getContentPane();
jpanel1.setLayout(flowlayout2);
jpanel1.add(username);
jpanel1.add(txtusername);
jpanel1.add(usersex);
jpanel1.add(csex);
jpanel1.add(userstatus);
jpanel1.add(cstatus);
jpanel1.add(usertel);
jpanel1.add(txtusertel);
jpanel1.add(userfamily);
jpanel1.add(txtuserfamily);
jpanel1.add(roomnumber);
jpanel1.add(txtroomnumber);
jpanel1.add(userbirth);
jpanel1.add(txtuserbirth);
jpanel1.add(userjob);
jpanel1.add(txtuserjob);
jpanel1.add(button_ok);
jpanel1.add(button_cancel);
jpanel1.add(button_modify);

button_ok.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
String name=txtusername.getText();
String c1=(String)csex.getSelectedItem();
String c2=(String)cstatus.getSelectedItem();
String tel=txtusertel.getText();
String family=txtuserfamily.getText();
String room=txtroomnumber.getText();
String birth=txtuserbirth.getText();
String job=txtuserjob.getText();
String sql="insert into ill values('txtusername.getText()','csex.getSelectedItem()','cstatus.getSelectedItem()','txtusertel.getText()','txtuserfamily.getText()','txtroomnumber.getText()','txtuserbirth.getText()','txtuserjob.getText()')";

String url=new String();
url="jdbc:oracle:thin:@192.168.0.9:1521:orcl:68659423";
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection(url,"system","jojeylin");
Statement stmt=con.createStatement();
stmt.executeUpdate(sql);
stmt.close();
con.close();
System.out.print("写入成功");
}
catch(ClassNotFoundException ex){
System.err.print(ex.getMessage());
}
catch(SQLException ex){
System.out.println("\n***SQLException caught ***\n");
}
}
});
}
}

...全文

111 15 打赏收藏转发到动态举报

写回复

用AI写文章

15 条回复

切换为时间正序

请发表友善的回复…

发表回复

shiri123 2008-03-13

打赏
举报

是不是应该是
String sql="insert into ill values("+txtusername.getText()+","+csex.getSelectedItem()+","+cstatus.getSelectedItem()+","+txtusertel.getText()+","+txtuserfamily.getText()+","+txtroomnumber.getText()+","+txtuserbirth.getText()+","+txtuserjob.getText()+")";

shiri123 2008-03-13