得分:70
package com.ambow;
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import oracle.sql.DATE;
public class InsertStuBase {
private String url="jdbc:oracle:thin:@localhost:1521:XE";
private String user="shimin";
private String password="shimin";
//public void insertStud(int USERID,String NAME,String PASSWD,String PHONE,String EMAIL,String REG_DATE){
public void insertStud(String EMAIL,int USERID){
Connection conn=null;
Statement stmt=null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(url, user, password);
stmt = conn.createStatement();
//String sqlStr = "insert into USERS(USERID,NAME,PASSWD,PHONE,EMAIL,REG_DATE) " +
//"values(" +USERID+",'"+NAME+"','"+PASSWD+"','"+PHONE+"','"+EMAIL+"',to_date('"+REG_DATE+"','yyyy-mm-dd'))";
//String sqlStr="delete from users where userid ="+USERID;
String sqlStr="update users set email='"+EMAIL+"' where userid="+USERID;
int resNum = stmt.executeUpdate(sqlStr);
if(resNum>0){
System.out.println("修改成功!");
}else{
System.out.println("修改失败!");
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
stmt.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void main(String[]args){
InsertStuBase c=new InsertStuBase();
c.insertStud("357509541@,2);
}
}