一个令我寝食难安的问题!!! 又来,至少你得给个insert语句吧,或者至少库结构贴出来啊 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 //:SqlServerJdbcDirect.javaimport java.sql.*;public class SqlServerJdbcDirect { public static void main(String[] args){ String dbUrl="jdbc:microsoft:sqlserver://tsc:1433;user=sa;password=mdzly109;DatabaseName=NorthWind"; Connection con; Statement stmt,stmtSelect; String user; ResultSet result=null; try{ //使用MS提供的JDBC类。需要下载SQL Server的JDBC库。 Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); }catch(ClassNotFoundException ex){ ex.printStackTrace(); } try{ //简单的使用 con = DriverManager.getConnection(dbUrl); stmt=con.createStatement(); String strTemp; strTemp="\'China xi an\'"; //在这里写你的insert into语句 stmt.executeUpdate("insert into Region(RegionDescription) values("+strTemp+")"); //stmt.executeUpdate("delete Region where RegionID=5"); result=stmt.executeQuery("select * from Region"); while (result.next()){ System.out.println(result.getInt(1)+" "+result.getString(2)); } con.close(); }catch(SQLException ex){ System.err.println("SQLException: " + ex.getMessage()); } }} package untitled27;import java.awt.*;import java.awt.event.*;import javax.swing.*;import javax.swing.border.*;import java.sql.Connection;import java.sql.DriverManager;import java.sql.Statement;import java.sql.ResultSet;import com.borland.dx.sql.dataset.*;import com.borland.dbswing.*;import java.sql.PreparedStatement;public class Frame1 extends JFrame { private JPanel contentPane; private JLabel 请填写 = new JLabel(); private JLabel 规格 = new JLabel(); private JLabel 数量 = new JLabel(); private JLabel 单价 = new JLabel(); private JLabel 日期 = new JLabel(); private JLabel 供应商 = new JLabel(); private JButton 入帐 = new JButton(); private JButton 退出 = new JButton(); private JdbTextField jdbTextField1 = new JdbTextField(); private JdbTextField jdbTextField2 = new JdbTextField(); private JdbTextField jdbTextField3 = new JdbTextField(); private JdbTextField jdbTextField4 = new JdbTextField(); private JdbTextField jdbTextField5 = new JdbTextField(); private Database dbset = new Database(); private QueryDataSet queryDataSet1 = new QueryDataSet(); //Construct the frame public Frame1() { enableEvents(AWTEvent.WINDOW_EVENT_MASK); try { jbInit(); } catch(Exception e) { e.printStackTrace(); } } //Component initialization private void jbInit() throws Exception { //setIconImage(Toolkit.getDefaultToolkit().createImage(Frame1.class.getResource("[Your Icon]"))); contentPane = (JPanel) this.getContentPane(); 请填写.setText("请填写下面内容:"); 请填写.setBounds(new Rectangle(33, 18, 133, 22)); contentPane.setLayout(null); this.setSize(new Dimension(405, 300)); this.setTitle("入货记帐"); 规格.setFont(new java.awt.Font("Dialog", 0, 15)); 规格.setText("规 格:"); 规格.setBounds(new Rectangle(45, 62, 56, 22)); 数量.setFont(new java.awt.Font("Dialog", 0, 15)); 数量.setText("数 量:"); 数量.setBounds(new Rectangle(211, 63, 55, 21)); 单价.setFont(new java.awt.Font("Dialog", 0, 15)); 单价.setText("单 价:"); 单价.setBounds(new Rectangle(45, 108, 61, 18)); 日期.setFont(new java.awt.Font("Dialog", 0, 15)); 日期.setText("日 期:"); 日期.setBounds(new Rectangle(210, 106, 55, 22)); 供应商.setFont(new java.awt.Font("Dialog", 0, 15)); 供应商.setText("供应商:"); 供应商.setBounds(new Rectangle(42, 155, 64, 22)); 入帐.setBounds(new Rectangle(101, 220, 84, 27)); 入帐.setText("入帐"); 入帐.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(ActionEvent e) { 入帐_actionPerformed(e); } }); 退出.setBounds(new Rectangle(227, 221, 84, 27)); 退出.setText("退出"); 退出.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(ActionEvent e) { 退出_actionPerformed(e); } }); jdbTextField1.setBackground(Color.white); jdbTextField1.setColumnName("规格"); jdbTextField1.setDataSet(queryDataSet1); jdbTextField1.setBounds(new Rectangle(96, 62, 81, 22)); jdbTextField2.setBackground(Color.white); jdbTextField2.setColumnName("单价"); jdbTextField2.setDataSet(queryDataSet1); jdbTextField2.setBounds(new Rectangle(96, 104, 81, 22)); jdbTextField3.setBackground(Color.white); jdbTextField3.setColumnName("数量"); jdbTextField3.setDataSet(queryDataSet1); jdbTextField3.setBounds(new Rectangle(264, 59, 81, 22)); jdbTextField4.setBackground(Color.white); jdbTextField4.setColumnName("日期"); jdbTextField4.setDataSet(queryDataSet1); jdbTextField4.setBounds(new Rectangle(264, 103, 81, 22)); jdbTextField5.setBackground(Color.white); jdbTextField5.setColumnName("供应商"); jdbTextField5.setDataSet(queryDataSet1); jdbTextField5.setBounds(new Rectangle(96, 153, 247, 22)); dbset.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:javadb", "mydogqiqi", "518701", false, "sun.jdbc.odbc.JdbcOdbcDriver"));queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(dbset, "select * from 入货表", null, true, Load.ALL)); contentPane.add(请填写, null); contentPane.add(规格, null); contentPane.add(数量, null); contentPane.add(单价, null); contentPane.add(日期, null); contentPane.add(供应商, null); contentPane.add(jdbTextField2, null); contentPane.add(jdbTextField3, null); contentPane.add(jdbTextField4, null); contentPane.add(jdbTextField5, null); contentPane.add(入帐, null); contentPane.add(退出, null); contentPane.add(jdbTextField1, null); } //Overridden so we can exit when window is closed protected void processWindowEvent(WindowEvent e) { super.processWindowEvent(e); if (e.getID() == WindowEvent.WINDOW_CLOSING) { System.exit(0); } } void 入帐_actionPerformed(ActionEvent e) { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String url="jdbc.odbc.javadb"; Connection con=DriverManager.getConnection(url); ; PreparedStatement stmt=con.prepareStatement("Insert Into 入货表(规格,数量,单价,日期,供应商) Values(?,?,?,?,?)"); stmt.setString(2,jdbTextField2.getText()); stmt.setString(3,jdbTextField3.getText()); stmt.setString(4,jdbTextField4.getText()); stmt.setString(5,jdbTextField5.getText()); stmt.executeQuery(); stmt.close(); con.close(); }catch(Exception g){} } void 退出_actionPerformed(ActionEvent e) {System.exit(0); }这是我的程序,请帮忙看一下! 你是动态生成SQL语句吗?如果是就自己来拼字符串好了. String id = "007";String name = "布什";String sql = insert table(id,name) values('"+id+"','"+name+"')";办法比较傻,但挺实用的 这个怎么翻译比较好呢?“Taking a Heap Dump” 关于tree的简单的问题 菜鸟问题:程序运行出错判断 菜鸟提问:请问如何在Stack里面push一个整形数 这样先用程序预编译jsp JAVA应用程序里怎样嵌套html网页?急 那位大哥能详细解释一下这几句代码啊?...详细一点,谢谢! 救救我呀!关于SOCKET! java里有没有办法得到一个表里的字段名 用javascript如何在子窗口中设定父窗口中某个表单的值。 毕业设计郁闷中,大家能帮我想一个创意,JAVA编写,网络或数据库方面的!!!(急急急) 为什么Socket连接会失败?
import java.sql.*;public class SqlServerJdbcDirect {
public static void main(String[] args){
String dbUrl="jdbc:microsoft:sqlserver://tsc:1433;user=sa;password=mdzly109;DatabaseName=NorthWind";
Connection con;
Statement stmt,stmtSelect;
String user;
ResultSet result=null;
try{
//使用MS提供的JDBC类。需要下载SQL Server的JDBC库。
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}catch(ClassNotFoundException ex){
ex.printStackTrace();
} try{
//简单的使用
con = DriverManager.getConnection(dbUrl);
stmt=con.createStatement();
String strTemp;
strTemp="\'China xi an\'";
//在这里写你的insert into语句
stmt.executeUpdate("insert into Region(RegionDescription) values("+strTemp+")");
//stmt.executeUpdate("delete Region where RegionID=5");
result=stmt.executeQuery("select * from Region");
while (result.next()){
System.out.println(result.getInt(1)+" "+result.getString(2));
}
con.close();
}catch(SQLException ex){
System.err.println("SQLException: " + ex.getMessage());
}
}
}
import java.awt.event.*;
import javax.swing.*;
import javax.swing.border.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import com.borland.dx.sql.dataset.*;
import com.borland.dbswing.*;
import java.sql.PreparedStatement;public class Frame1 extends JFrame {
private JPanel contentPane;
private JLabel 请填写 = new JLabel();
private JLabel 规格 = new JLabel();
private JLabel 数量 = new JLabel();
private JLabel 单价 = new JLabel();
private JLabel 日期 = new JLabel();
private JLabel 供应商 = new JLabel();
private JButton 入帐 = new JButton();
private JButton 退出 = new JButton(); private JdbTextField jdbTextField1 = new JdbTextField();
private JdbTextField jdbTextField2 = new JdbTextField();
private JdbTextField jdbTextField3 = new JdbTextField();
private JdbTextField jdbTextField4 = new JdbTextField();
private JdbTextField jdbTextField5 = new JdbTextField();
private Database dbset = new Database();
private QueryDataSet queryDataSet1 = new QueryDataSet(); //Construct the frame
public Frame1() {
enableEvents(AWTEvent.WINDOW_EVENT_MASK);
try {
jbInit();
}
catch(Exception e) {
e.printStackTrace();
}
}
//Component initialization
private void jbInit() throws Exception {
//setIconImage(Toolkit.getDefaultToolkit().createImage(Frame1.class.getResource("[Your Icon]")));
contentPane = (JPanel) this.getContentPane();
请填写.setText("请填写下面内容:");
请填写.setBounds(new Rectangle(33, 18, 133, 22));
contentPane.setLayout(null);
this.setSize(new Dimension(405, 300));
this.setTitle("入货记帐");
规格.setFont(new java.awt.Font("Dialog", 0, 15));
规格.setText("规 格:");
规格.setBounds(new Rectangle(45, 62, 56, 22));
数量.setFont(new java.awt.Font("Dialog", 0, 15));
数量.setText("数 量:");
数量.setBounds(new Rectangle(211, 63, 55, 21));
单价.setFont(new java.awt.Font("Dialog", 0, 15));
单价.setText("单 价:");
单价.setBounds(new Rectangle(45, 108, 61, 18));
日期.setFont(new java.awt.Font("Dialog", 0, 15));
日期.setText("日 期:");
日期.setBounds(new Rectangle(210, 106, 55, 22));
供应商.setFont(new java.awt.Font("Dialog", 0, 15));
供应商.setText("供应商:");
供应商.setBounds(new Rectangle(42, 155, 64, 22));
入帐.setBounds(new Rectangle(101, 220, 84, 27));
入帐.setText("入帐");
入帐.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(ActionEvent e) {
入帐_actionPerformed(e);
}
});
退出.setBounds(new Rectangle(227, 221, 84, 27));
退出.setText("退出");
退出.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(ActionEvent e) {
退出_actionPerformed(e);
}
}); jdbTextField1.setBackground(Color.white);
jdbTextField1.setColumnName("规格");
jdbTextField1.setDataSet(queryDataSet1);
jdbTextField1.setBounds(new Rectangle(96, 62, 81, 22));
jdbTextField2.setBackground(Color.white);
jdbTextField2.setColumnName("单价");
jdbTextField2.setDataSet(queryDataSet1);
jdbTextField2.setBounds(new Rectangle(96, 104, 81, 22));
jdbTextField3.setBackground(Color.white);
jdbTextField3.setColumnName("数量");
jdbTextField3.setDataSet(queryDataSet1);
jdbTextField3.setBounds(new Rectangle(264, 59, 81, 22));
jdbTextField4.setBackground(Color.white);
jdbTextField4.setColumnName("日期");
jdbTextField4.setDataSet(queryDataSet1);
jdbTextField4.setBounds(new Rectangle(264, 103, 81, 22));
jdbTextField5.setBackground(Color.white);
jdbTextField5.setColumnName("供应商");
jdbTextField5.setDataSet(queryDataSet1);
jdbTextField5.setBounds(new Rectangle(96, 153, 247, 22));
dbset.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:javadb", "mydogqiqi", "518701", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(dbset, "select * from 入货表", null, true, Load.ALL)); contentPane.add(请填写, null);
contentPane.add(规格, null);
contentPane.add(数量, null);
contentPane.add(单价, null);
contentPane.add(日期, null);
contentPane.add(供应商, null); contentPane.add(jdbTextField2, null);
contentPane.add(jdbTextField3, null);
contentPane.add(jdbTextField4, null);
contentPane.add(jdbTextField5, null);
contentPane.add(入帐, null);
contentPane.add(退出, null);
contentPane.add(jdbTextField1, null);
}
//Overridden so we can exit when window is closed
protected void processWindowEvent(WindowEvent e) {
super.processWindowEvent(e);
if (e.getID() == WindowEvent.WINDOW_CLOSING) {
System.exit(0);
}
} void 入帐_actionPerformed(ActionEvent e) { try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc.odbc.javadb";
Connection con=DriverManager.getConnection(url);
;
PreparedStatement stmt=con.prepareStatement("Insert Into 入货表(规格,数量,单价,日期,供应商) Values(?,?,?,?,?)");
stmt.setString(2,jdbTextField2.getText());
stmt.setString(3,jdbTextField3.getText());
stmt.setString(4,jdbTextField4.getText());
stmt.setString(5,jdbTextField5.getText());
stmt.executeQuery();
stmt.close();
con.close();
}catch(Exception g){}
} void 退出_actionPerformed(ActionEvent e) {
System.exit(0);
}
这是我的程序,请帮忙看一下!
如果是就自己来拼字符串好了.
String name = "布什";
String sql = insert table(id,name) values('"+id+"','"+name+"')";
办法比较傻,但挺实用的