数据库连接的基本问题,100分等待,不够可加.. 应该是你的SQL语句写的有问题吧。注意,Access对SQL的标准支持的并不完整,有很多东西用不了的 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 这个不是我写的....是书上给的代码.copy下来的就是不可以用,,,,我是在学习阶段的......请高手赐教 Access的连接有问题,你连接部分好象没写出来啊? 你把那个用别的数据库试试你用的那个Access本来就不好 aceess还可以我就是用这个 ............................................ //面板panel_buttongroup1_label_text_buttongruop2设置 panel_buttongroup1_label_text_buttongruop2.setLayout(new BorderLayout()); panel_buttongroup1_label_text_buttongruop2.add(panelButtonGroup1,"North"); panel_buttongroup1_label_text_buttongruop2.add(panel_label_text,"Center"); panel_buttongroup1_label_text_buttongruop2.add(panelButtonGroup2,"South"); Border operEtched=BorderFactory.createEtchedBorder(); Border operTitled=BorderFactory.createTitledBorder (operEtched,"数据库操作显示",TitledBorder.CENTER, TitledBorder.TOP,new Font("SansSerif",Font.BOLD,20), Color.red); panel_buttongroup1_label_text_buttongruop2.setBorder(operTitled); //面板panelQuery设置 panelQuery.setLayout(new GridLayout(1,3)); button_que.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ dataQuery(); } }); panelQuery.add(label_que); panelQuery.add(txtFieldQue); panelQuery.add(button_que); //表格设置 //建立表格 table_que = new JTable(tm); table_que.setToolTipText("显示全部查询结果"); table_que.setCellSelectionEnabled(false); table_que.setShowVerticalLines(true); table_que.setShowHorizontalLines(true); //table_que.setEnabled(false); //建立scroll Pane panelScroll = new JScrollPane(table_que); //面板panelTable设置 panelTable.setLayout(new BorderLayout()); panelTable.add(panelScroll,"Center"); Border queryEtched=BorderFactory.createEtchedBorder(); Border queryTitled=BorderFactory.createTitledBorder (queryEtched,"数据库查询显示",TitledBorder.CENTER, TitledBorder.TOP,new Font("SansSerif",Font.BOLD,20), Color.red); panelQuery.setBorder(queryTitled);........................................... private void insertData() { isInsert = true; panelButtonGroup1.setVisible(false); button_insert.setEnabled(false); button_update.setEnabled(false); button_delete.setEnabled(false); button_commite.setEnabled(true); button_cancel.setEnabled(true); for(int i=1; i<=fields.size(); i++){ JTextField txtField = (JTextField) fields.get(i-1); txtField.setText(""); txtField.setEditable(true); txtField.setBackground(Color.white); } try{ conIns.rs.moveToInsertRow(); }catch(Exception e){ System.out.print("Error in insert Data." +e); System.exit(1); } } private void updateData(){ panelButtonGroup1.setVisible(false); button_insert.setEnabled(false); button_update.setEnabled(false); button_delete.setEnabled(false); button_commite.setEnabled(true); button_cancel.setEnabled(true); for(int i=1; i<=fields.size(); i++){ JTextField txtField = (JTextField) fields.get(i-1); txtField.setEditable(true); txtField.setBackground(Color.white); } try{ conIns.rs.moveToCurrentRow(); }catch(Exception e){ System.out.print("Error in update Data." +e); System.exit(1); } } private void commitData(){ try{ ResultSetMetaData rsmd = conIns.rs.getMetaData(); //conIns.rs.moveToCurrentRow(); for(int i =1 ; i<= fields.size(); i++) { JTextField txtField = (JTextField)fields.get(i-1); String value = txtField.getText().trim(); String name = rsmd.getColumnName(i).trim().toUpperCase(); conIns.rs.updateString(name, value); txtField.setEditable(false); } if(isInsert) conIns.rs.insertRow(); else conIns.rs.updateRow(); conIns.rs.moveToCurrentRow(); panelButtonGroup1.setVisible(true); button_insert.setEnabled(true); button_update.setEnabled(true); button_delete.setEnabled(true); button_commite.setEnabled(false); button_cancel.setEnabled(false); conIns.rs.refreshRow(); loadData(); enableButton(); }catch(Exception e){ System.out.print("Error in commit data." +e); System.exit(1); } } private void cancelData(){ try{ for(int i =1; i<=fields.size(); i++){ JTextField txtField = (JTextField)fields.get(i-1); txtField.setEditable(false); } conIns.rs.moveToCurrentRow(); panelButtonGroup1.setVisible(true); button_insert.setEnabled(true); button_update.setEnabled(true); button_delete.setEnabled(true); button_commite.setEnabled(false); button_cancel.setEnabled(false); conIns.rs.refreshRow(); loadData(); enableButton(); }catch(Exception e){ System.exit(1); } } private void deleteData(){ try{ int CursorPos = conIns.rs.getRow(); conIns.rs.deleteRow(); conIns.rs.absolute(CursorPos-1); conIns.rs.refreshRow(); loadData(); enableButton(); }catch(Exception e){ System.out.print("Error in delete Data." +e); System.exit(1); } }我想问题是出在这两个地方吧希望可以给点提示 http://expert.csdn.net/Expert/TopicView1.asp?id=3063668 request.getParameter()接受的数据为什么为空啊 类的加载问题? 配电脑 如何有效去除StringBuffer中字符串的最后一个非空字符???? 关于用JAVA做嵌入式开发的前景,请各位指教 为什么权限高的线程运行次数反而少? 关于BigDecimal的一个问题 jsp中怎样调用Servlet? 请问java可以实现在客户端驻留的东西吗?像activex一样。谢谢 多形和运行期类型识别有何关系? sqlserver2000的uniqueidentifier类型!!!! 那位进来看看我的水平如何,帮帮忙,谢谢!
就是不可以用,,,,我是在学习阶段的......
请高手赐教
我就是用这个
//面板panel_buttongroup1_label_text_buttongruop2设置
panel_buttongroup1_label_text_buttongruop2.setLayout(new BorderLayout());
panel_buttongroup1_label_text_buttongruop2.add(panelButtonGroup1,"North");
panel_buttongroup1_label_text_buttongruop2.add(panel_label_text,"Center");
panel_buttongroup1_label_text_buttongruop2.add(panelButtonGroup2,"South"); Border operEtched=BorderFactory.createEtchedBorder();
Border operTitled=BorderFactory.createTitledBorder
(operEtched,"数据库操作显示",TitledBorder.CENTER,
TitledBorder.TOP,new Font("SansSerif",Font.BOLD,20),
Color.red);
panel_buttongroup1_label_text_buttongruop2.setBorder(operTitled);
//面板panelQuery设置
panelQuery.setLayout(new GridLayout(1,3));
button_que.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
dataQuery();
}
});
panelQuery.add(label_que);
panelQuery.add(txtFieldQue);
panelQuery.add(button_que);
//表格设置
//建立表格
table_que = new JTable(tm);
table_que.setToolTipText("显示全部查询结果");
table_que.setCellSelectionEnabled(false);
table_que.setShowVerticalLines(true);
table_que.setShowHorizontalLines(true);
//table_que.setEnabled(false); //建立scroll Pane
panelScroll = new JScrollPane(table_que);
//面板panelTable设置
panelTable.setLayout(new BorderLayout());
panelTable.add(panelScroll,"Center");
Border queryEtched=BorderFactory.createEtchedBorder();
Border queryTitled=BorderFactory.createTitledBorder
(queryEtched,"数据库查询显示",TitledBorder.CENTER,
TitledBorder.TOP,new Font("SansSerif",Font.BOLD,20),
Color.red);
panelQuery.setBorder(queryTitled);
...........................................
private void insertData() {
isInsert = true;
panelButtonGroup1.setVisible(false);
button_insert.setEnabled(false);
button_update.setEnabled(false);
button_delete.setEnabled(false);
button_commite.setEnabled(true);
button_cancel.setEnabled(true);
for(int i=1; i<=fields.size(); i++){
JTextField txtField = (JTextField) fields.get(i-1);
txtField.setText("");
txtField.setEditable(true);
txtField.setBackground(Color.white); }
try{
conIns.rs.moveToInsertRow();
}catch(Exception e){
System.out.print("Error in insert Data." +e);
System.exit(1); }
}
private void updateData(){
panelButtonGroup1.setVisible(false);
button_insert.setEnabled(false);
button_update.setEnabled(false);
button_delete.setEnabled(false);
button_commite.setEnabled(true);
button_cancel.setEnabled(true);
for(int i=1; i<=fields.size(); i++){
JTextField txtField = (JTextField) fields.get(i-1);
txtField.setEditable(true);
txtField.setBackground(Color.white);
}
try{
conIns.rs.moveToCurrentRow();
}catch(Exception e){
System.out.print("Error in update Data." +e);
System.exit(1); }
}
private void commitData(){
try{
ResultSetMetaData rsmd = conIns.rs.getMetaData();
//conIns.rs.moveToCurrentRow(); for(int i =1 ; i<= fields.size(); i++) {
JTextField txtField = (JTextField)fields.get(i-1);
String value = txtField.getText().trim();
String name = rsmd.getColumnName(i).trim().toUpperCase();
conIns.rs.updateString(name, value);
txtField.setEditable(false);
}
if(isInsert)
conIns.rs.insertRow();
else
conIns.rs.updateRow();
conIns.rs.moveToCurrentRow();
panelButtonGroup1.setVisible(true);
button_insert.setEnabled(true);
button_update.setEnabled(true);
button_delete.setEnabled(true);
button_commite.setEnabled(false);
button_cancel.setEnabled(false);
conIns.rs.refreshRow();
loadData();
enableButton();
}catch(Exception e){
System.out.print("Error in commit data." +e);
System.exit(1);
}
}
private void cancelData(){
try{
for(int i =1; i<=fields.size(); i++){
JTextField txtField = (JTextField)fields.get(i-1);
txtField.setEditable(false);
}
conIns.rs.moveToCurrentRow();
panelButtonGroup1.setVisible(true);
button_insert.setEnabled(true);
button_update.setEnabled(true);
button_delete.setEnabled(true);
button_commite.setEnabled(false);
button_cancel.setEnabled(false);
conIns.rs.refreshRow();
loadData();
enableButton();
}catch(Exception e){
System.exit(1); }
}
private void deleteData(){
try{
int CursorPos = conIns.rs.getRow();
conIns.rs.deleteRow();
conIns.rs.absolute(CursorPos-1);
conIns.rs.refreshRow();
loadData();
enableButton();
}catch(Exception e){
System.out.print("Error in delete Data." +e);
System.exit(1); }
}我想问题是出在这两个地方吧希望可以给点提示