Question

java 中如何使用sql插入语句

sql语句如下：insert into room
values('3-001','豪华间','双人间','0','null','null',' ','null')如何将其转换为Java语句中插入

Answer 1

public int save(Notices notice) throws SQLException{
String sql = "insert into noticeinfo(notice_title,notice_type,notice_content,notice_add_time,user_id,user_table_id,class_table_id,notice_state,is_important)"+"values(?,?,?,?,?,?,?,?,?)";
PreparedStatement pstmt = super.getConnection().prepareStatement(sql);
pstmt.setString(1, notice.getNotice_title());
pstmt.setInt(2, notice.getNotice_type());
pstmt.setString(3, notice.getNotice_content());
pstmt.setTimestamp(4, new Timestamp(System.currentTimeMillis()));
pstmt.setString(5, notice.getUser_id());
pstmt.setInt(6, notice.getUser_table_id());
pstmt.setInt(7, notice.getClass_table_id());
pstmt.setInt(8, notice.getNotice_state());
pstmt.setInt(9, notice.getIs_important());
int i = pstmt.executeUpdate();
return i;
}

Answer 2

？"Insert Into room Values('"
+ jTRoomNum.getText().trim() + "','"
+ jStandard.getSelectedItem().toString() + ",'"
+ jRoomKind.getSelectedItem().toString()
+ "0,'"
+ jTARemark.getText()+ ",?,?)'") 前面你加了单引号，后面没有结束的单引号。看标出粗体，后面也一样。

Answer 3

你是sql语句有问题,我下面加星号的地方是后面对应vlaues的值,一般不要写星号.
string sql="insert into room * values('3-001','豪华间','双人间','0','null','null',' ','null')"
daoClient.queryForList(sql);
我用的是jdbc这里就不细说了

Answer 4

"Insert Into room Values('"
+ jTRoomNum.getText().trim() + ",'"
+ jStandard.getSelectedItem().toString() + ",'"
+ jRoomKind.getSelectedItem().toString()
+ "0,'"
+ jTARemark.getText()+ ",?,?)'")你这个没错，但是不怎么安全。可以注入SQL语句。

Answer 5

Connection conn = DriverManager.getConnection(DBC_URL, DBC_USER, DBC_PASSWORD);
Statement stm=conn.createStatement();
ResultSet rs=stm.executeQuery(sql);
返回一个结果集