关于vj的一个问题，晚上就结算

[ephemeral]

在数据库连接好后，怎么给字段赋值。
最好能给我一个实例程序。包括数据库的查找，更新，删除，添加！谢谢！

[ephemeral]

up,谁来帮帮我啊？？

[skyyoung]

Statement stmt;
String sql;
int rows;

sql = "INSERT INTO tCust "
+ "(custId, custName, custAddr) "
+ "VALUES "
+ "('" + custId + "',"
+ "('" + custName + "',"
+ "('" + custAddr + "')";

stmt = theConn.dbConn.createStatement();
rows = stmt.executeUpdate(sql);
theConn.dbConn.commit();
stmt.close();



A PreparedStatement is used to insert data containing QUOTES PreparedStatement stmt = null;
String sql;
int rows;

try {
sql = "INSERT INTO tCust"
+ "(custName) "
+ "VALUES "
+ "(?)";
stmt = theConn.dbConn.prepareStatement(sql);
stmt.setString(1, "Name with \" are permitted!");
rows = stmt.executeUpdate();
theConn.dbConn.commit();
stmt.close();
System.out.println(sql);
}
catch (Exception e){
e,printStackTrace();
}
========================================
PreparedStatement prepstmt;
try {
prepstmt = theConn.dbConn.prepareStatement
("DELETE FROM tCust "+
" WHERE custId = ?");

prepstmt.setString(1,cust_id.getText());
prepstmt.executeUpdate();

theConn.dbConn.commit();
prepstmt.close();
}
catch (Exception e) {
e.printStackTrace();
}

[skyyoung]

PreparedStatement prepstmt;
try {
prepstmt = theConn.dbConn.prepareStatement
("UPDATE tCust SET custName = ? "+
" WHERE custId = ?");
prepstmt.setString(1,"Smith");
prepstmt.setString(2, cust_id.getText());
prepstmt.executeUpdate();

theConn.dbConn.commit();
prepstmt.close();
}
catch (Exception e) {
e.printStackTrace();
}

[ephemeral]

skyyoung兄，我是用ado连接access数据库，怎么作？

[ephemeral]

up again!

[kookoo]

msdn中没有吗？

[kookoo]

msdn中没有吗？

[ephemeral]

是不是没人用VJ啊？我命苦~~~~~~~~~``

[billbenz]

我们实习做过，你的email?我发给你

[kiddycoffee]

建议看一看 SQL 语句。
如果用一般的查询，直接用

Connection conn = ....;
Statement stmt = conn.creatStatement();
String sql = "update into ... set ... ";
stmt.excuteUpdate(sql);

就可以了。
简单的查询，一般不要用到事物处理和 perpareStatement（楼上的），因为事物处理和 perpareStatement 都需要额外的开销。

[kiddycoffee]

还有最好不要用 VJ 开发，要么 %100 JAVA，要么转向其它开发工具，比如 C#,Deiphi 什么的。

[ephemeral]

我的email [e-mail]