JSF 入门实例 代码

package com.xh.service; import java.io.IOException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import org.junit.Test; import com.xh.entity.User; public class UserService { PreparedStatement pstm = null; ResultSet rs = null; public int sava(User user) throws ClassNotFoundException, SQLException { Class.forName("oracle.jdbc.driver.OracleDriver"); Connection conn = DriverManager.getConnection( "jdbc:oracle:thin:@localhost:1521:ORA", "scott", "xiaohe"); String sql = "insert into tb_user values(?,?,?)"; PreparedStatement pstm = conn.prepareStatement(sql); pstm.setInt(1, user.getId()); pstm.setString(2, user.getName()); pstm.setString(3, user.getPassword()); int result = 0; result = pstm.executeUpdate(); pstm.close(); conn.close(); return result; } public User getUserByNamePassword(String name, String password) throws IOException, ClassNotFoundException, SQLException { // 获取连接 Class.forName("oracle.jdbc.driver.OracleDriver"); Connection conn = DriverManager.getConnection( "jdbc:oracle:thin:@localhost:1521:ORA", "scott", "xiaohe"); String sql = "select u.name,u.password from tb_user u where u.name=? and u.password=?"; User user = null; pstm = conn.prepareStatement(sql); pstm.setString(1, name); pstm.setString(2, password); rs = pstm.executeQuery(); if (rs.next()) { user = new User(); user.setName(rs.getString("name")); user.setPassword(rs.getString("password")); } rs.close(); pstm.close(); conn.close(); return user; } @Test public void aa() throws ClassNotFoundException, SQLException { UserService a = new UserService(); User u = new User(); u.setId(001111); u.setName("jsfTest"); u.setPassword("Ok"); int result = a.sava(u); System.out.println(result); } }