:
或者
封装起来:DbUtils类
package lj.util;
import java.sql.*;
public class DbUtils {
private static String DRIVER = "net.sourceforge.jtds.jdbc.Driver";
private static String URL = "jdbc:jtds:sqlserver://localhost:1433/LibDb";
public final static int PAGE_SIZE=2;
private static String USERID = "test";
private static String UERPASSWORD = "test";
// 禁止实例对象
private DbUtils() {
}
static {
try {
Class.forName(DRIVER);
} catch (Exception e) {
e.printStackTrace();
}
}
// 获得打开的数据连接
public static Connection getConnection() {
Connection conn = null;
try {
conn = DriverManager.getConnection(URL, USERID, UERPASSWORD);
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
// 关闭数据集/语句/连接对象
public static void close(ResultSet rs, Statement st, Connection conn) {
try {
if (rs != null)
rs.close();
if (st != null)
st.close();
if (conn != null)
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
下面是小知识点java.sql.Date->java.util.Date
java.util.Date->java.sql.Date
将Date转化为特定格式
HTML:
<html>
<head>
<meta http-equiv="Content-Type"
content="text/html; charset=UTF-8">
<style type="text/css">
.colorRed{ color:red; }
#colorBlue{ color:blue; }
</style>
</head>
<body>
<h1 class="colorRed" >I am h1 </h1>
<h1 id="colorBlue" >I am h1 </h1>
<a href="http://news.sina.com.cn" >新浪新闻</a>
<h1 >I am h1 </h1>
</body>
</html>
转向自己页面和新页面
<a href="exam011.html" target="_self">
<a href="exam011.html" target="_blank">
<table border="1">
<caption>标题</caption>
<thead>
<tr><th>表头列1</th><th>表头列2</th></tr>
</thead>
<tbody>
<tr><td>单元格11</td><td>单元格12</td></tr>
<tr><td>单元格21</td><td>单元格22</td></tr>
</tbody>
</table>
运行结果
<!DOCTYPE html>
<body>
<ul>
<li>咖啡</li>
<li>茶</li>
<li>牛奶</li>
</ul>
</body>
</html>
无序列表
Form表单:
主要属性:
method(post or get),action(goto url),target
input元素:
<form method="post" action="http://localhost/toy/">
<fieldset>
<legend>简介</legend>
<textarea id="userMemo" rows="10" cols="30"></textarea>
</fieldset>
<input type="submit" value="提交" />
</form>
文本域运行结果如下:
<form method="post" action="http://localhost/toy/">
<fieldset>
<legend>个人信息</legend>
姓名:<input type="text" name="userName" width="20" /> </br>
性别:<input type="radio" name="userGender" value="man"
checked />男
<input type="radio" name="userGender" value="woman" />
女</br>
年龄:<select name="userAge" >
<option value="20-30" >20-30</option>
<option value="30-40" selected >30-40</option>
</select> </br>
爱好:<input name="userLike" type="checkbox"
value="music">音乐
<input name="userLike" type="checkbox"
value="sport">运动
<input name="userLike" type="checkbox"
value="literal">文学</br>
简介:<textarea name="userMemo"
cols="40" rows="5" ></textarea></br>
<input type="submit" value="提交" />
</fieldset>
</form>