MyEclipse+tomcat+struts+Oracle做的一个小项目,改用Mysql数据库,数据库连接采用的是数据池。<data-sources>
<data-source key="mysql"
type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="driverClassName"
value="com.mysql.jdbc.Driver" />
<set-property property="url"
value="jdbc:mysql://localhost:3306/chen" />
<set-property property="username" value="root" />
<set-property property="password" value="chen" />
<set-property property="maxCount" value="20" />
<set-property property="minCount" value="5" />
<set-property property="autoCommit" value="true" />
<set-property property="readOnly" value="false" />
<set-property property="description" value="ds" />
</data-source>
报空指针异常,public boolean validateUser(String name, String password) {
Connection con = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
String sql = "select * from admin where username=? and password=?";
boolean flag = false;
try {
con = ds.getConnection();
<data-source key="mysql"
type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="driverClassName"
value="com.mysql.jdbc.Driver" />
<set-property property="url"
value="jdbc:mysql://localhost:3306/chen" />
<set-property property="username" value="root" />
<set-property property="password" value="chen" />
<set-property property="maxCount" value="20" />
<set-property property="minCount" value="5" />
<set-property property="autoCommit" value="true" />
<set-property property="readOnly" value="false" />
<set-property property="description" value="ds" />
</data-source>
报空指针异常,public boolean validateUser(String name, String password) {
Connection con = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
String sql = "select * from admin where username=? and password=?";
boolean flag = false;
try {
con = ds.getConnection();
解决方案 »
- log4j:WARN No appenders could be found for logger 如何解决该警告?
- ★请教个关于相对路径的问题,请高手指教
- struts2属性设置问题!
- 把文本内容存到数据库后如何带格式的取出来?
- <c:forEach>输出arraylist出错了,帮忙啊
- jsp导出excel问题
- VLAN是否支持C/S结构的网络产品,急急急!(送出全部分数)
- 动态单选框问题 求助
- javaBeans的问题?
- 紧急求救!在线等。求求各位高手帮我解答一下。小弟是个jsp新手,分都送完了,我感激大家帮我。
- java.sql.SQLException: 列名无效
- 为什么第一次可以输入正确值,再次刷新页面就永远不行
1、mysql jdbc包没有
2、你类中引用的类可能引错了。建议仔细查看下。小问题