JDBC的PrepareStatement

<wbr></wbr>

public class Information {
<wbr><wbr><wbr><wbr><wbr><wbr> String id="";<br><wbr><wbr><wbr><wbr><wbr><wbr> String name="";<br><wbr><wbr><wbr><wbr><wbr><wbr> String advice="";<br><wbr>public String getAdvice() {<br><wbr><wbr>return advice;<br><wbr>}<br><wbr>public void setAdvice(String advice) {<br><wbr><wbr>this.advice = advice;<br><wbr>}<br><wbr>public String getId() {<br><wbr><wbr>return id;<br><wbr>}<br><wbr>public void setId(String id) {<br><wbr><wbr>this.id = id;<br><wbr>}<br><wbr>public String getName() {<br><wbr><wbr>return name;<br><wbr>}<br><wbr>public void setName(String name) {<br><wbr><wbr>this.name = name;<br><wbr>}<br><wbr><wbr><wbr><wbr><wbr><wbr><br> }<br></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>

<wbr></wbr>

public class JdbcTest {<wbr></wbr>

<wbr><br><wbr>public static void main(String[] args) throws ClassNotFoundException, SQLException {<br><wbr><wbr>// TODO Auto-generated method stub<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> Class.forName("oracle.jdbc.driver.OracleDriver");<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@192.168.9.29:1521:ac","bre","123");<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> //用PreparedStatement实现，每次执行一个条件<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> //插入<br><wbr><wbr><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> PreparedStatement pstmt0 =conn.prepareStatement("INSERT INTO Information VALUES</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>

<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> (?, ?, ?)");<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> pstmt0.setString(1, "111");<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> pstmt0.setString(2, "周鑫");<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> pstmt0.setString(3, "开心");<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> int rtn0=pstmt0.executeUpdate();<br><wbr><wbr><wbr><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr> //更改<br><wbr><wbr><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> PreparedStatement pstmt1 =conn.prepareStatement("UPDATE INFORMATION SET ADVICE=?WHERE</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>

<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> NAME=?");<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> pstmt1.setString(1, "xxxx");<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> pstmt1.setString(2, "aaaaa");<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> int rtn1=pstmt1.executeUpdate();<br><wbr><wbr><wbr><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> //删除<br><wbr><wbr><wbr><wbr><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> PreparedStatement pstmt2 =conn.prepareStatement("DELETE INFORMATION WHERE NAME=?");<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> pstmt2.setString(1, "aaaaa");<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> int rtn2=pstmt2.executeUpdate();<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> //查询<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> PreparedStatement pstmt3 =conn.prepareStatement("SELECT * FROM INFORMATION");<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> int rtn3=pstmt3.executeUpdate();<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> ResultSet rset1 =pstmt3.getResultSet();<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> while(rset1.next())<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> {<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>String s1=rset1.getString(1);<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>String s2=rset1.getString(2);<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>String s3=rset1.getString(3);<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> System.out.println(s1+"\t"+s2+"\t"+s3);<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> }<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> rset1.close();<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> pstmt3.close();<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> pstmt3.close();<br><wbr><wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>