java代码:
String sql = "insert into user_tab values(?,?,?)";
PreparedStatement ps = null;
try
{
ps = connection.prepareStatement(sql);
ps.setString(1, user.getUserName());
ps.setString(2, user.getPassword());
ps.setString(3, user.getAge());
if (ps.executeUpdate() > 0)
{
System.out.println("data in base ok");
}
}
catch (SQLException e)
{
System.out.println(e.getMessage());
}
2.配置文件
Class.forName("oracle.jdbc.driver.OracleDriver");
String userName = "admin";
String passWord = "admin";
String url = "jdbc:oracle:thin:@localhost:1521:XE";
CONNECTION = DriverManager.getConnection(url,userName, passWord);
System.out.println("database connect success");
3.cmd>select * fromuser_tab;
表或视图不存在